DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on HZ_CUST_ACCOUNTS

Line 719: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,

715: =============================================================================*/
716:
717: PROCEDURE CalculateCumKeyClient (
718: -- Parameter definition was changed TCA obsolescence project.
719: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
720: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
721: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
722: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
723: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,

Line 1306: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,

1302: =============================================================================*/
1303:
1304: PROCEDURE CalculateSupplierCumClient (
1305: -- Parameter definition was changed TCA obsolescence project.
1306: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
1307: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
1308: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1309: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1310: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,

Line 3083: FROM HZ_CUST_ACCOUNTS CUST_ACCT

3079: v_level := 'CUSTOMER_NUMBER';
3080: -- Following query is changed as per TCA obsolescence project.
3081: SELECT CUST_ACCT.ACCOUNT_NUMBER
3082: INTO x_customer_number
3083: FROM HZ_CUST_ACCOUNTS CUST_ACCT
3084: WHERE CUST_ACCT.CUST_ACCOUNT_ID = x_cum_key_record.customer_id;
3085: END IF;
3086:
3087: END IF;

Line 3225: FROM HZ_CUST_ACCOUNTS CUST_ACCT

3221: v_level := 'CUSTOMER_NUMBER';
3222: -- Following query is changed as per TCA obsolescence project.
3223: SELECT CUST_ACCT.ACCOUNT_NUMBER
3224: INTO x_customer_number
3225: FROM HZ_CUST_ACCOUNTS CUST_ACCT
3226: WHERE CUST_ACCT.CUST_ACCOUNT_ID = v_customer_id;
3227: END IF;
3228:
3229: IF v_ship_to_org_id IS NOT NULL THEN