[Home] [Help]
48: -- 11-Feb-2004 dmvincen Added currency conversion during bulk update.
49: -- 20-feb-2004 sunkumar modified list queries. bug#3370252
50: -- 23-feb-2004 sunkumar modified leads/opp. query for list for org. contact
51: -- 26-feb-2004 sunkumar used HZ tables to get data for list queries
52: -- 09-Mar-2004 dmvincen Moved hz_cust_accounts into exists clause.
53: -- 11-May-2004 sunkumar bug#3611891:LIST EFFECTIVENESS SHOWS WRONG NO OF LEADS
54: -- 25-May-2004 sunkumar bug#3578292:INVOICE REV COL GETS POPULATED W/O INVOICING IN LIST EFF
55: -- 08-Jun-2004 dmvincen BUG#3488796: PERF: Invoiced revenue to use exists clause
56: -- 23-Jun-2004 dmvincen BUG3704598: PERF: List queries.
2283: (SELECT H.header_id, H.flow_status_code, H.org_id,
2284: H.transactional_curr_code currency_code,
2285: list_parties.object_type,
2286: list_parties.object_id
2287: FROM oe_order_headers_all H, hz_cust_accounts A
2288: , (
2289: -- SELECT DISTINCT LIST OF B2C AND B2B PARTIES
2290: SELECT distinct actlist_source.source_code_for_id,
2291: actlist_source.arc_source_code_for,
2930: AND SRC.SOURCE_CATEGORY in ('B2C','B2B')
2931: AND REL.PARTY_ID(+) = ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID
2932: AND REL.DIRECTIONAL_FLAG(+) = 'F'
2933: ) csch_parties,
2934: hz_cust_accounts account,
2935: oe_order_headers_all H,
2936: oe_order_lines_all I,
2937: ams_act_products aprod
2938: where csch_parties.primary_party_id = account.party_id
3075: AND SRC.SOURCE_CATEGORY in ('B2C','B2B')
3076: AND REL.PARTY_ID(+) = ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID
3077: AND REL.DIRECTIONAL_FLAG(+) = 'F'
3078: ) csch_parties,
3079: hz_cust_accounts account,
3080: oe_order_headers_all H,
3081: oe_order_lines_all I,
3082: ams_act_products aprod
3083: where csch_parties.primary_party_id = account.party_id
3410: csch_parties.ACTIVITY_METRIC_ID,
3411: primary_party_id, contact_rel_party_id
3412: from AMS_INFMET_ORDER_GT csch_parties,
3413: ams_act_products aprod,
3414: hz_cust_accounts account,
3415: oe_order_headers_all H,
3416: oe_order_lines_all I
3417: where csch_parties.primary_party_id = account.party_id
3418: AND H.sold_to_org_id = account.cust_account_id