APPS.AMS_ACTMETRICS_SEED_PVT dependencies on AMS_INFMET_ORDER_GT

Line 3317: /* INSERT INTO AMS_INFMET_ORDER_GT(PRIMARY_PARTY_ID, CONTACT_REL_PARTY_ID,

3313: 'Activity Count='||l_activity_count);
3314: END IF;
3315:
3316: if l_has_enabled > 0 then
3317: /* INSERT INTO AMS_INFMET_ORDER_GT(PRIMARY_PARTY_ID, CONTACT_REL_PARTY_ID,
3318: LAST_ACTIVATION_DATE, ACTIVITY_METRIC_ID, SOURCE_CATEGORY, OBJECT_ID)
3319: SELECT decode(SRC.SOURCE_CATEGORY, 'B2C', ENTRY.PARTY_ID,
3320: 'B2B', REL.OBJECT_ID, null) PRIMARY_PARTY_ID,
3321: decode(SRC.SOURCE_CATEGORY, 'B2C', NULL,

Line 3353: l_sql_stmt := 'INSERT INTO AMS_INFMET_ORDER_GT(PRIMARY_PARTY_ID, CONTACT_REL_PARTY_ID,

3349: AND REL.PARTY_ID(+) = ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID
3350: AND REL.DIRECTIONAL_FLAG(+) = 'F'; */
3351:
3352: -- Splitting the SQL between order number metrices and revenue metrices
3353: l_sql_stmt := 'INSERT INTO AMS_INFMET_ORDER_GT(PRIMARY_PARTY_ID, CONTACT_REL_PARTY_ID,
3354: LAST_ACTIVATION_DATE, ACTIVITY_METRIC_ID, SOURCE_CATEGORY, OBJECT_ID)
3355: SELECT decode(SRC.SOURCE_CATEGORY, ''B2C'', ENTRY.PARTY_ID,
3356: ''B2B'', REL.OBJECT_ID, null) PRIMARY_PARTY_ID,
3357: decode(SRC.SOURCE_CATEGORY, ''B2C'', NULL,

Line 3412: from AMS_INFMET_ORDER_GT csch_parties,

3408: SELECT /*+ ordered USE_NL(ACCOUNT H) */ H.header_id, H.transactional_curr_code currency_code,
3409: sum(nvl(I.ordered_quantity * I.unit_selling_price,0)) booked_revenue,
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