APPS.BIC_SUMMARY_EXTRACT_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 1436: and exists (select 'x' from oe_order_headers_all oeh,

1432: --1-jan-2003 inorder to calculate retention_churned
1433: between trunc(add_months(g_period_start_date,g_attrition_period*-1)) and trunc(g_period_end_date)
1434: and x_account_established_date
1435: <= add_months(bdt.act_period_end_date, g_attrition_period*-1)
1436: and exists (select 'x' from oe_order_headers_all oeh,
1437: hz_cust_accounts hca
1438: where oeh.sold_to_org_id = hca.cust_account_id
1439: and hca.party_id = x_party_id
1440: and ordered_date between add_months(bdt.act_period_end_date,

Line 1445: (select 'x' from oe_order_headers_all oeh,

1441: g_attrition_period*-1)+1
1442: and bdt.act_period_end_date
1443: )
1444: and (exists
1445: (select 'x' from oe_order_headers_all oeh,
1446: hz_cust_accounts hca
1447: where oeh.sold_to_org_id = hca.cust_account_id
1448: and hca.party_id = x_party_id
1449: and ordered_date between add_months(bdt.act_period_end_date,

Line 1543: and exists (select 'x' from oe_order_headers_all oeh,

1539: -- 1-apr-99 and 30-jun-99 and not between 31-mar-99 and 30-jun-99.
1540: -- 30-jun-99 minus 3 months will return 31-mar-99
1541: --
1542: -- for same reasons 1 is added while comparing ordered_date
1543: and exists (select 'x' from oe_order_headers_all oeh,
1544: hz_cust_accounts hca
1545: where oeh.sold_to_org_id = hca.cust_account_id
1546: and hca.party_id = x_party_id
1547: and ordered_date between add_months(bdt.act_period_end_date,

Line 1552: (select 'x' from oe_order_headers_all oeh,

1548: g_attrition_period*-1)+1
1549: and bdt.act_period_end_date
1550: )
1551: and not exists
1552: (select 'x' from oe_order_headers_all oeh,
1553: hz_cust_accounts hca
1554: where oeh.sold_to_org_id = hca.cust_account_id
1555: and hca.party_id = x_party_id
1556: and ordered_date between add_months(bdt.act_period_end_date,

Line 2117: from oe_order_headers_all aoh, --4434468 replaced aso_i_oe_order_headers_v with oe_order_headers_all

2113: g_program_application_id,
2114: g_program_id,
2115: g_last_update_login,
2116: 'ACTIVATION'
2117: from oe_order_headers_all aoh, --4434468 replaced aso_i_oe_order_headers_v with oe_order_headers_all
2118: bic_party_summary bcs,
2119: hz_cust_accounts acct
2120: where bcs.measure_id = g_measure_id_for_acqu
2121:

Line 2361: x_org_id oe_order_headers_all.org_id % type;

2357: x_returns number;
2358: x_return_qty oe_order_lines_all.ordered_quantity % type;
2359: x_return_amt oe_order_lines_all.unit_selling_price % type;
2360: x_party_id hz_parties.party_id % type;
2361: x_org_id oe_order_headers_all.org_id % type;
2362: x_start_date date;
2363: begin
2364: --dbms_output.put_line(to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
2365: open c_orders;

Line 2437: x_org_id oe_order_headers_all.org_id % type;

2433: x_ontime_val oe_order_lines_all.unit_selling_price % type;
2434: x_del_val oe_order_lines_all.unit_selling_price % type;
2435:
2436: x_party_id hz_parties.party_id % type;
2437: x_org_id oe_order_headers_all.org_id % type;
2438: x_start_date date;
2439: begin
2440: --dbms_output.put_line(to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
2441: open c_orders;