APPS.RLM_CUM_SV dependencies on HZ_CUST_SITE_USES

Line 1699: FROM HZ_CUST_SITE_USES

1695: --
1696: -- Following query is changed as per TCA obsolescence project.
1697: SELECT CUST_ACCT_SITE_ID
1698: INTO v_cum_key_record.ship_to_address_id
1699: FROM HZ_CUST_SITE_USES
1700: WHERE site_use_id = v_ship_to_site_use_id
1701: AND site_use_code = 'SHIP_TO';
1702: --
1703: ELSE

Line 1718: FROM HZ_CUST_SITE_USES

1714: --
1715: -- Following query is changed as per TCA obsolescence project.
1716: SELECT CUST_ACCT_SITE_ID
1717: INTO v_cum_key_record.intrmd_ship_to_address_id
1718: FROM HZ_CUST_SITE_USES
1719: WHERE site_use_id = v_intrmd_ship_to_site_use_id
1720: AND site_use_code = 'SHIP_TO';
1721: --
1722: ELSE

Line 1737: FROM HZ_CUST_SITE_USES

1733: --
1734: -- Following query is changed as per TCA obsolescence project.
1735: SELECT CUST_ACCT_SITE_ID
1736: INTO v_cum_key_record.bill_to_address_id
1737: FROM HZ_CUST_SITE_USES
1738: WHERE site_use_id = v_bill_to_site_use_id
1739: AND site_use_code = 'BILL_TO';
1740: --
1741: ELSE

Line 3234: FROM HZ_CUST_SITE_USES

3230: v_level := 'SHIP_TO_ADDRESS_ID';
3231: -- Following query is changed as per TCA obsolescence project.
3232: SELECT CUST_ACCT_SITE_ID
3233: INTO v_ship_to_address_id
3234: FROM HZ_CUST_SITE_USES
3235: WHERE site_use_id = v_ship_to_org_id
3236: AND site_use_code = 'SHIP_TO';
3237:
3238: IF v_ship_to_address_id IS NOT NULL THEN

Line 3260: FROM HZ_CUST_SITE_USES

3256: v_level := 'BILL_TO_ADDRESS_ID';
3257: -- Following query is changed as per TCA obsolescence project.
3258: SELECT CUST_ACCT_SITE_ID
3259: INTO v_bill_to_address_id
3260: FROM HZ_CUST_SITE_USES
3261: WHERE site_use_id = v_bill_to_org_id
3262: AND site_use_code = 'BILL_TO';
3263:
3264: IF v_bill_to_address_id IS NOT NULL THEN

Line 3282: FROM HZ_CUST_SITE_USES

3278: v_level := 'INTRMD_SHIP_TO_ADDRESS_ID';
3279: -- Following query is changed as per TCA obsolescence project.
3280: SELECT CUST_ACCT_SITE_ID
3281: INTO v_intrmd_ship_to_address_id
3282: FROM HZ_CUST_SITE_USES
3283: WHERE site_use_id = v_intmed_ship_to_org_id
3284: AND site_use_code = 'SHIP_TO';
3285:
3286: IF v_intrmd_ship_to_address_id IS NOT NULL THEN

Line 3543: FROM HZ_CUST_SITE_USES

3539: --
3540: -- Following query is changed as per TCA obsolescence project.
3541: SELECT CUST_ACCT_SITE_ID
3542: INTO v_ship_to_address_id
3543: FROM HZ_CUST_SITE_USES
3544: WHERE site_use_id = x_ship_to_org_id
3545: AND site_use_code = 'SHIP_TO';
3546:
3547: -- Find the intrmd_ship_to_address_id

Line 3560: FROM HZ_CUST_SITE_USES

3556: --
3557: -- Following query is changed as per TCA obsolescence project.
3558: SELECT CUST_ACCT_SITE_ID
3559: INTO v_intrmd_ship_to_address_id
3560: FROM HZ_CUST_SITE_USES
3561: WHERE site_use_id = x_intrmd_ship_to_org_id
3562: AND site_use_code = 'SHIP_TO';
3563: --
3564: ELSE

Line 3589: FROM HZ_CUST_SITE_USES

3585: --
3586: -- Following query is changed as per TCA obsolescence project.
3587: SELECT CUST_ACCT_SITE_ID
3588: INTO v_bill_to_address_id
3589: FROM HZ_CUST_SITE_USES
3590: WHERE site_use_id = x_bill_to_org_id
3591: AND site_use_code = 'BILL_TO';
3592: --
3593: ELSE