APPS.MRPP_CMERGE_FCST dependencies on RA_CUSTOMER_MERGES

Line 57: FROM MRP_FORECAST_DATES yt, ra_customer_merges m

53: ,yt.TRANSACTION_ID
54: ,yt.customer_id
55: ,yt.ship_id
56: ,yt.bill_id
57: FROM MRP_FORECAST_DATES yt, ra_customer_merges m
58: WHERE (
59: yt.customer_id = m.DUPLICATE_ID
60: OR yt.ship_id = m.DUPLICATE_SITE_ID
61: OR yt.bill_id = m.DUPLICATE_SITE_ID

Line 224: FROM MRP_FORECAST_DESIGNATORS yt, ra_customer_merges m

220: ,yt.FORECAST_DESIGNATOR
221: ,yt.customer_id
222: ,yt.ship_id
223: ,yt.bill_id
224: FROM MRP_FORECAST_DESIGNATORS yt, ra_customer_merges m
225: WHERE (
226: yt.customer_id = m.DUPLICATE_ID
227: OR yt.ship_id = m.DUPLICATE_SITE_ID
228: OR yt.bill_id = m.DUPLICATE_SITE_ID

Line 389: FROM MRP_FORECAST_UPDATES yt, ra_customer_merges m

385: ,yt.TRANSACTION_ID
386: ,yt.customer_id
387: ,yt.ship_id
388: ,yt.bill_id
389: FROM MRP_FORECAST_UPDATES yt, ra_customer_merges m
390: WHERE (
391: yt.customer_id = m.DUPLICATE_ID
392: OR yt.ship_id = m.DUPLICATE_SITE_ID
393: OR yt.bill_id = m.DUPLICATE_SITE_ID

Line 573: FROM MRP_SALES_ORDER_UPDATES yt, ra_customer_merges m

569: ,current_bill_id
570: ,previous_customer_id
571: ,previous_bill_id
572: ,previous_ship_id
573: FROM MRP_SALES_ORDER_UPDATES yt, ra_customer_merges m
574: WHERE (
575: yt.current_customer_id = m.DUPLICATE_ID
576: OR yt.current_ship_id = m.DUPLICATE_SITE_ID
577: OR yt.current_bill_id = m.DUPLICATE_SITE_ID

Line 748: FROM MRP_SR_ASSIGNMENTS yt, ra_customer_merges m

744: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
745: ,yt.ASSIGNMENT_ID
746: ,yt.customer_id
747: ,yt.ship_to_site_id
748: FROM MRP_SR_ASSIGNMENTS yt, ra_customer_merges m
749: WHERE (
750: yt.customer_id = m.DUPLICATE_ID
751: OR yt.ship_to_site_id = m.DUPLICATE_SITE_ID
752: ) AND yt.assignment_type in (4,5,6)

Line 762: from ra_customer_merges r1, (

758: select v1.assignment_set_id, v1.assignment_type,
759: v1.organization_id, r1.duplicate_id, r1.duplicate_site_id,
760: v1.sourcing_rule_type, v1.inventory_item_id, v1.category_id,
761: v1.customer_id, v1.customer_site_id
762: from ra_customer_merges r1, (
763: select m.number2 assignment_set_id,
764: m.number3 assignment_type,
765: nvl(m.number4, -23453) organization_id,
766: nvl(r.customer_id, -23453) customer_id,

Line 772: from msc_form_query m, ra_customer_merges r

768: m.number7 sourcing_rule_type,
769: nvl(m.number8, -23453) inventory_item_id,
770: nvl(m.number9, -23453) category_id,
771: count(*)
772: from msc_form_query m, ra_customer_merges r
773: where m.number5 = r.duplicate_id
774: and m.number6 = r.duplicate_site_id
775: and m.query_id = q_id
776: and r.process_flag = 'N'

Line 803: l_customer_id ra_customer_merges.customer_id%type;

799: l_organization_id msc_form_query.number4%type;
800: l_sourcing_rule_type msc_form_query.number7%type;
801: l_inventory_item_id msc_form_query.number8%type;
802: l_category_id msc_form_query.number9%type;
803: l_customer_id ra_customer_merges.customer_id%type;
804: l_customer_site_id ra_customer_merges.customer_site_id%type;
805:
806: q_id number;
807:

Line 804: l_customer_site_id ra_customer_merges.customer_site_id%type;

800: l_sourcing_rule_type msc_form_query.number7%type;
801: l_inventory_item_id msc_form_query.number8%type;
802: l_category_id msc_form_query.number9%type;
803: l_customer_id ra_customer_merges.customer_id%type;
804: l_customer_site_id ra_customer_merges.customer_site_id%type;
805:
806: q_id number;
807:
808: BEGIN

Line 844: from mrp_sr_assignments m, ra_customer_merges r

840: m.ship_to_site_id,
841: m.sourcing_rule_type,
842: m.inventory_item_id,
843: m.category_id
844: from mrp_sr_assignments m, ra_customer_merges r
845: where (m.customer_id = r.duplicate_id
846: and m.ship_to_site_id = r.duplicate_site_id)
847: and m.assignment_type in (4, 5, 6)
848: and r.process_flag = 'N'