APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on HZ_CUST_ACCOUNTS

Line 296: FROM HZ_Cust_Accounts;

292: FII_UTIL.put_line(g_state);
293: end if;
294:
295: SELECT nvl(MAX(Cust_Account_ID),-1) INTO l_max_cust_account_id
296: FROM HZ_Cust_Accounts;
297:
298: UPDATE FII_Change_Log
299: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)
300: = (SELECT l_max_cust_account_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)

Line 308: --From HZ_Cust_Accounts, outer join to FII_Customer_Hierarchies to:

304: INSERT INTO FII_Change_Log (Log_Item, Item_Value, Creation_Date, Created_By, Last_Update_Date, Last_Update_Login, Last_Updated_By)
305: VALUES ('MAX_CUST_ACCOUNT_ID', l_max_cust_account_id, sysdate, g_fii_user_id, sysdate, g_fii_login_id, g_fii_user_id);
306: END IF;
307:
308: --From HZ_Cust_Accounts, outer join to FII_Customer_Hierarchies to:
309: --1. Populate FII_Customer_Hierarchies with non-hierarchical customers. Use
310: -- the first account from each unique party in HZ_Cust_Accounts.
311: --2. Populate FII_Cust_Accounts with hierarchical and non-hierarchical customers.
312:

Line 310: -- the first account from each unique party in HZ_Cust_Accounts.

306: END IF;
307:
308: --From HZ_Cust_Accounts, outer join to FII_Customer_Hierarchies to:
309: --1. Populate FII_Customer_Hierarchies with non-hierarchical customers. Use
310: -- the first account from each unique party in HZ_Cust_Accounts.
311: --2. Populate FII_Cust_Accounts with hierarchical and non-hierarchical customers.
312:
313: g_state := 'Populating FII_Customer_Hierarchies with non-hierarchical customers and FII_Cust_Accounts with all customers.';
314: if g_debug_flag = 'Y' then

Line 419: FROM HZ_Cust_Accounts CA,

415: CA.Account_Number,
416: ROW_NUMBER () OVER (
417: PARTITION BY CA.Party_ID
418: ORDER BY CA.Party_ID NULLS LAST) SRLID
419: FROM HZ_Cust_Accounts CA,
420: FII_Customer_Hierarchies Hier
421: WHERE CA.Party_ID = Hier.Child_Party_ID (+)
422: AND CA.Cust_Account_ID <= l_max_cust_account_id;
423:

Line 882: FROM HZ_Cust_Accounts

878: FII_UTIL.put_line(g_state);
879: end if;
880:
881: SELECT nvl(MAX(Cust_Account_ID),-1) INTO l_max_cust_account_id
882: FROM HZ_Cust_Accounts
883: WHERE Cust_Account_ID >= l_prev_max_cust_account_id;
884:
885: UPDATE FII_Change_Log
886: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)

Line 898: FROM HZ_Cust_Accounts CA

894: end if;
895:
896: INSERT INTO FII_AR_Caccts_Delta_GT(Cust_Account_ID, Party_ID, Account_Number)
897: SELECT Cust_Account_ID, Party_ID, Account_Number
898: FROM HZ_Cust_Accounts CA
899: WHERE EXISTS (SELECT 1 FROM FII_AR_Parties_Delta_GT Log
900: WHERE Log.Party_ID = CA.Party_ID)
901: OR (Cust_Account_ID > l_prev_max_cust_account_id
902: AND Cust_Account_ID <= l_max_cust_account_id);