APPS.RLM_SHIP_DELIVERY_PATTERN_SV dependencies on HZ_CUST_ACCT_SITES

Line 2351: HZ_CUST_ACCT_SITES ACCT_SITE

2347: SELECT ETG.TP_GROUP_CODE
2348: INTO x_tp_group_code
2349: FROM ECE_TP_GROUP ETG,
2350: ECE_TP_HEADERS ETH,
2351: HZ_CUST_ACCT_SITES ACCT_SITE
2352: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
2353: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
2354: and ACCT_SITE.CUST_ACCOUNT_ID = x_Input.ShiptoCustomerId
2355: and ACCT_SITE.CUST_ACCT_SITE_ID = x_Input.ShipToAddressId;

Line 2375: FROM HZ_CUST_ACCT_SITES ACCT_SITE

2371: --
2372: -- Following query is changed as per TCA obsolescence project.
2373: SELECT ece_tp_location_code
2374: INTO x_ship_to_ece_locn_code
2375: FROM HZ_CUST_ACCT_SITES ACCT_SITE
2376: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_Input.ShipToAddressId;
2377: --
2378: EXCEPTION
2379: --

Line 2396: FROM HZ_CUST_ACCT_SITES ACCT_SITE

2392: --
2393: -- Following query is changed as per TCA obsolescence project.
2394: SELECT ece_tp_location_code
2395: INTO x_bill_to_ece_locn_code
2396: FROM HZ_CUST_ACCT_SITES ACCT_SITE
2397: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_Input.BillToAddressId;
2398: --
2399: EXCEPTION
2400: --

Line 2418: FROM HZ_CUST_ACCT_SITES ACCT_SITE

2414: --
2415: -- Following query is changed as per TCA obsolescence project.
2416: SELECT ece_tp_location_code
2417: INTO x_inter_ship_to_ece_locn_code
2418: FROM HZ_CUST_ACCT_SITES ACCT_SITE
2419: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_Input.IntShipToAddressId;
2420: --
2421: EXCEPTION
2422: --