APPS.FII_AP_INV_SUM_INIT dependencies on AP_HOLDS_ALL

Line 1109: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';

1105: TRUNCATE_TABLE('MLOG$_FII_AP_INV_HOLDS_B');
1106: TRUNCATE_TABLE('FII_AP_INV_HOLDS_B');
1107:
1108:
1109: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';
1110: if g_debug_flag = 'Y' then
1111: FII_UTIL.put_line(g_state);
1112: FII_UTIL.start_timer;
1113: FII_UTIL.put_line('');

Line 1171: FROM AP_Holds_All AH,

1167: sysdate Creation_Date,
1168: g_fii_user_id Last_Updated_By,
1169: sysdate Last_Update_Date,
1170: g_fii_login_id Last_Update_Login
1171: FROM AP_Holds_All AH,
1172: FII_AP_Invoice_B AI
1173: WHERE AH.Invoice_ID = AI.Invoice_ID
1174: AND AI.Cancel_Date IS NULL
1175: AND AI.Invoice_Type NOT IN ('PREPAYMENT')

Line 6491: g_state := 'Populating FII_AP_HOLD_HIST_B FROM AP_HOLDS_ALL table';

6487: TRUNCATE_TABLE('MLOG$_FII_AP_HOLD_HIST_B');
6488: TRUNCATE_TABLE('FII_AP_HOLD_HIST_B');
6489:
6490:
6491: g_state := 'Populating FII_AP_HOLD_HIST_B FROM AP_HOLDS_ALL table';
6492: if g_debug_flag = 'Y' then
6493: FII_UTIL.put_line(g_state);
6494: end if;
6495:

Line 6563: FROM AP_Holds_All h

6559: FROM (SELECT /*+ parallel(h) no_merge full(h) */
6560: Invoice_ID,
6561: Hold_Date,
6562: DECODE(Release_Lookup_Code, NULL, g_sysdate, last_update_date) Release_Date
6563: FROM AP_Holds_All h
6564: WHERE Hold_Date >= g_start_date
6565: AND Hold_Date+0 <= g_end_date --workaround for pq-between bug
6566: ) h
6567: )

Line 6585: FROM AP_Holds_All h

6581: Invoice_ID,
6582: Hold_Date,
6583: DECODE(Release_Lookup_Code, NULL, g_sysdate, Last_Update_Date) Release_Date,
6584: Release_Lookup_Code
6585: FROM AP_Holds_All h
6586: WHERE Hold_Date >= g_start_date
6587: AND Hold_Date+0 <= g_end_date -- workaround for pq-between bug
6588: ) h
6589: )

Line 6620: FROM AP_Holds_ALL AH1, AP_Holds_ALL AH2

6616: WHERE HH1.Action = 'H'
6617: AND HH1.Invoice_ID = HH.Invoice_ID
6618: AND HH1.Action_Date IN
6619: (SELECT MIN(TRUNC(AH1.Hold_Date))
6620: FROM AP_Holds_ALL AH1, AP_Holds_ALL AH2
6621: WHERE AH1.Invoice_ID = HH.Invoice_ID
6622: AND AH2.Invoice_ID = HH.Invoice_ID
6623: AND TRUNC(AH2.Last_Update_Date) = HH.Action_Date
6624: AND AH2.Release_Lookup_Code IS NOT NULL

Line 6652: FROM AP_Holds_ALL AH

6648: end if;
6649:
6650: UPDATE FII_AP_Hold_Hist_B HH
6651: SET Hold_Count = (SELECT DECODE(HH.Action,'H', COUNT(*), -1 * COUNT(*))
6652: FROM AP_Holds_ALL AH
6653: WHERE AH.Invoice_ID = HH.Invoice_ID
6654: AND (EXISTS (SELECT 'Hold Exists'
6655: FROM FII_AP_Hold_Hist_B HH1
6656: WHERE HH1.Invoice_ID = AH.Invoice_ID