APPS.RLM_VALIDATEDEMAND_SV dependencies on ECE_TP_HEADERS

Line 279: ECE_TP_HEADERS eth

275: --
276: SELECT DISTINCT ACCT_SITE.CUST_ACCOUNT_ID
277: INTO v_shipToCustomerId
278: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
279: ECE_TP_HEADERS eth
280: WHERE ACCT_SITE.tp_header_id = eth.tp_header_id
281: AND ACCT_SITE.ece_tp_location_code = v_Group_rec.cust_ship_to_ext
282: AND eth.TP_REFERENCE_EXT1 = v_Customer;
283: --

Line 5612: ece_tp_headers eth

5608: -- Following query is changed as per TCA obsolescence project.
5609: SELECT DISTINCT ACCT_SITE.CUST_ACCOUNT_ID
5610: INTO x_header_rec.customer_id
5611: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
5612: ece_tp_headers eth
5613: WHERE ACCT_SITE.tp_header_id = eth.tp_header_id
5614: AND ACCT_SITE.ece_tp_location_code = v_ShipToLoc
5615: AND eth.TP_REFERENCE_EXT1 = v_Customer;
5616: --

Line 9320: ECE_TP_HEADERS ETH,

9316: -- Following query is changed as per TCA obsolescence project.
9317: SELECT ETG.TP_GROUP_CODE
9318: INTO x_tp_group_code
9319: FROM ECE_TP_GROUP ETG,
9320: ECE_TP_HEADERS ETH,
9321: HZ_CUST_ACCT_SITES ACCT_SITE
9322: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9323: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
9324: and ACCT_SITE.CUST_ACCOUNT_ID = x_header_rec.CUSTOMER_ID

Line 9402: ECE_TP_HEADERS ETH,

9398: -- Following query is changed as per TCA obsolescence project.
9399: SELECT ETG.TP_GROUP_CODE
9400: INTO x_tp_group_code
9401: FROM ECE_TP_GROUP ETG,
9402: ECE_TP_HEADERS ETH,
9403: HZ_CUST_ACCT_SITES ACCT_SITE
9404: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9405: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
9406: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_header_rec.ECE_TP_LOCATION_CODE_EXT;