Siebel Sales, Oracle EBS, Siebel Marketing Campaign Related With Order:

Siebel Sales, Oracle EBS, Siebel Marketing Campaign Related to an Order:

1: Typical Sales Life Cycle:

Prospecting ----> Lead ----> opportunity ----> Quote ----> Order ----> Closure
ENTITIES (Accounts, Contacts, Opportunities, Quotes)

2: Oracle EBS Data flow for an Order

Order ----> Oracle Install Base ----> Service Contracts ----> AR ( Recievables)

3: Retrieve Contact Information of an Account for Orders Placed and target Set of Customer for Service related Orders and New orders

4: Siebel Campaign Load for the list being generated from Oracle EBs for list of contacts.

Programs ----> Campaigns ----> Offer ---->(Email) ----> Segment / List ---->Load/ Launch ----> Responses

Responses ----> Leads ----> Opportunities

5: Key Tables / Views Involved in the Modules:

ORACLE EBS:
TABLES:
RA_CUSTOMERS
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
HZ_CUST_ACCOUNTS
HZ_PARTIES
HZ_PARTY_SITES
HZ_LOCATIONS
HZ_CUST_ACCNT_SITES_ALL
HZ_CUST_SITE_USES_ALL
MTL_PARAMETERS
MTL_SYSTEM_ITEMS_B
CSI_SYSTEMS_B
CSI_ITEM_INSTANCES
CSI_SYSTEMS_TL
VIEWS:
AR_CONTACTS_V , CSI_SYSTEMS_V

Thanks
BSK