APPS.WSH_CUST_MERGE dependencies on RA_CUSTOMER_MERGES

Line 28: G_SITE_USE_CODE RA_CUSTOMER_MERGES.Customer_Site_Code%TYPE;

24: G_FROM_LOCATION_ID NUMBER;
25: G_TO_CUSTOMER_ID NUMBER;
26: G_TO_CUST_SITE_ID NUMBER;
27: G_TO_LOCATION_ID NUMBER;
28: G_SITE_USE_CODE RA_CUSTOMER_MERGES.Customer_Site_Code%TYPE;
29: G_BATCH_LIMIT CONSTANT NUMBER := 10000;
30:
31:
32: --

Line 3011: FROM ra_customer_merges

3007: customer_site_code
3008: BULK COLLECT INTO l_fromCustomerIdTab, l_toCustomerIdTab,
3009: l_fromCustomerSiteIdTab, l_toCustomerSiteIdTab, l_orgcustomerMergeHeaderIdTab,
3010: l_customerSiteCodeTab
3011: FROM ra_customer_merges
3012: WHERE process_flag = 'N'
3013: AND customer_site_code in ( 'SHIP_TO', 'DELIVER_TO' )
3014: AND request_id = Req_Id
3015: AND set_number = Set_Num;

Line 3019: -- { Record exists in Ra_Customer_Merges table

3015: AND set_number = Set_Num;
3016:
3017: IF l_fromCustomerIdTab.COUNT > 0
3018: THEN
3019: -- { Record exists in Ra_Customer_Merges table
3020: FOR i in l_fromCustomerIdTab.FIRST..l_fromCustomerIdTab.LAST
3021: LOOP
3022: -- { Main Loop
3023: -- Get Locations of the old/duplicate Site Use ID

Line 3235: -- } Record exists in Ra_Customer_Merges table

3231: -- }
3232: END IF;
3233: -- } Main Loop
3234: END LOOP;
3235: -- } Record exists in Ra_Customer_Merges table
3236: END IF;
3237: --} Not Process Lock
3238: END IF;
3239:

Line 3328: FROM WSH_PICKING_BATCHES yt, ra_customer_merges m

3324: CURSOR merged_records IS
3325: SELECT distinct CUSTOMER_MERGE_HEADER_ID
3326: ,BATCH_ID
3327: ,yt.customer_id
3328: FROM WSH_PICKING_BATCHES yt, ra_customer_merges m
3329: WHERE (
3330: yt.customer_id = m.DUPLICATE_ID
3331: ) AND m.process_flag = 'N'
3332: AND m.request_id = req_id

Line 3478: FROM WSH_CALENDAR_ASSIGNMENTS yt, ra_customer_merges m

3474: SELECT distinct CUSTOMER_MERGE_HEADER_ID
3475: ,CALENDAR_ASSIGNMENT_ID
3476: ,yt.customer_id
3477: ,yt.customer_site_use_id
3478: FROM WSH_CALENDAR_ASSIGNMENTS yt, ra_customer_merges m
3479: WHERE (
3480: yt.customer_id = m.DUPLICATE_ID
3481: OR yt.customer_site_use_id = m.DUPLICATE_SITE_ID
3482: ) AND m.process_flag = 'N'

Line 3620: FROM WSH_PICKING_RULES yt, ra_customer_merges m

3616: CURSOR merged_records IS
3617: SELECT distinct CUSTOMER_MERGE_HEADER_ID
3618: ,PICKING_RULE_ID
3619: ,yt.customer_id
3620: FROM WSH_PICKING_RULES yt, ra_customer_merges m
3621: WHERE (
3622: yt.customer_id = m.DUPLICATE_ID
3623: ) AND m.process_flag = 'N'
3624: AND m.request_id = req_id

Line 3751: ra_customer_merges rcm,

3747: WHERE EXISTS
3748: ( SELECT 'x'
3749: FROM wsh_delivery_details wdd,
3750: wsh_delivery_assignments wda,
3751: ra_customer_merges rcm,
3752: mtl_parameters mtl
3753: WHERE mtl.wms_enabled_flag = 'Y'
3754: AND mtl.organization_id = wdd.organization_id
3755: AND wda.parent_delivery_detail_id IS NOT NULL

Line 3850: ra_customer_merges rcm

3846: SELECT 1 FROM DUAL
3847: WHERE EXISTS
3848: ( SELECT 'x'
3849: FROM mtl_client_parameters_v mcp,
3850: ra_customer_merges rcm
3851: WHERE rcm.duplicate_id <> rcm.customer_id
3852: AND rcm.process_flag = 'N'
3853: AND rcm.request_id = Req_Id
3854: AND rcm.set_number = Set_Num