DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on HZ_CUST_ACCOUNTS

Line 718: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,

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

Line 1297: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,

1293: =============================================================================*/
1294:
1295: PROCEDURE CalculateSupplierCumClient (
1296: -- Parameter definition was changed TCA obsolescence project.
1297: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
1298: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
1299: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1300: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1301: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,

Line 3073: FROM HZ_CUST_ACCOUNTS CUST_ACCT

3069: v_level := 'CUSTOMER_NUMBER';
3070: -- Following query is changed as per TCA obsolescence project.
3071: SELECT CUST_ACCT.ACCOUNT_NUMBER
3072: INTO x_customer_number
3073: FROM HZ_CUST_ACCOUNTS CUST_ACCT
3074: WHERE CUST_ACCT.CUST_ACCOUNT_ID = x_cum_key_record.customer_id;
3075: END IF;
3076:
3077: END IF;

Line 3215: FROM HZ_CUST_ACCOUNTS CUST_ACCT

3211: v_level := 'CUSTOMER_NUMBER';
3212: -- Following query is changed as per TCA obsolescence project.
3213: SELECT CUST_ACCT.ACCOUNT_NUMBER
3214: INTO x_customer_number
3215: FROM HZ_CUST_ACCOUNTS CUST_ACCT
3216: WHERE CUST_ACCT.CUST_ACCOUNT_ID = v_customer_id;
3217: END IF;
3218:
3219: IF v_ship_to_org_id IS NOT NULL THEN