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)