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 9396: ECE_TP_HEADERS ETH,

9392: -- Following query is changed as per TCA obsolescence project.
9393: SELECT ETG.TP_GROUP_CODE
9394: INTO x_tp_group_code
9395: FROM ECE_TP_GROUP ETG,
9396: ECE_TP_HEADERS ETH,
9397: HZ_CUST_ACCT_SITES ACCT_SITE
9398: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9399: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
9400: and ACCT_SITE.CUST_ACCOUNT_ID = x_header_rec.CUSTOMER_ID

Line 9478: ECE_TP_HEADERS ETH,

9474: -- Following query is changed as per TCA obsolescence project.
9475: SELECT ETG.TP_GROUP_CODE
9476: INTO x_tp_group_code
9477: FROM ECE_TP_GROUP ETG,
9478: ECE_TP_HEADERS ETH,
9479: HZ_CUST_ACCT_SITES ACCT_SITE
9480: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9481: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
9482: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_header_rec.ECE_TP_LOCATION_CODE_EXT;