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 3014: FROM ra_customer_merges

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

Line 3022: -- { Record exists in Ra_Customer_Merges table

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

Line 3238: -- } Record exists in Ra_Customer_Merges table

3234: -- }
3235: END IF;
3236: -- } Main Loop
3237: END LOOP;
3238: -- } Record exists in Ra_Customer_Merges table
3239: END IF;
3240: --} Not Process Lock
3241: END IF;
3242:

Line 3331: FROM WSH_PICKING_BATCHES yt, ra_customer_merges m

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

Line 3481: FROM WSH_CALENDAR_ASSIGNMENTS yt, ra_customer_merges m

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

Line 3623: FROM WSH_PICKING_RULES yt, ra_customer_merges m

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

Line 3754: ra_customer_merges rcm,

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