[Home] [Help]
886: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)
887: = (SELECT NVL(l_max_cust_account_id, l_prev_max_cust_account_id), sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)
888: WHERE log_item = 'MAX_CUST_ACCOUNT_ID';
889:
890: g_state := 'Populate FII_AR_CAccts_Delta_GT with customer accounts that are new or in an updated hierarchy.';
891: if g_debug_flag = 'Y' then
892: FII_UTIL.put_line(g_state);
893: FII_UTIL.start_timer;
894: end if;
892: FII_UTIL.put_line(g_state);
893: FII_UTIL.start_timer;
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);
903:
904: if g_debug_flag = 'Y' then
905: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AR_CAccts_Delta_GT.');
906: FII_UTIL.stop_timer;
907: FII_UTIL.print_timer('Duration');
908: end if;
909:
972: CA.Account_Number,
973: ROW_NUMBER () OVER (
974: PARTITION BY CA.Party_ID
975: ORDER BY CA.Party_ID NULLS LAST) SRLID
976: FROM FII_AR_Caccts_Delta_GT CA,
977: (SELECT Parent_ID, Child_ID
978: FROM HZ_Hierarchy_Nodes
979: WHERE Hierarchy_Type = g_hierarchy_type
980: AND g_sysdate BETWEEN Effective_Start_Date AND Effective_End_Date) Hier
1114:
1115: SELECT *
1116: BULK COLLECT INTO FII_CAcct_Denorm_Old_MS
1117: FROM FII_Cust_Accounts CAD
1118: WHERE EXISTS (SELECT 1 FROM FII_AR_Caccts_Delta_GT Log
1119: WHERE Log.Cust_Account_ID = CAD.Cust_Account_ID)
1120: ORDER BY Parent_Party_ID, Cust_Account_ID;
1121:
1122: if g_debug_flag = 'Y' then