eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 588: ,ap_prepay_history_all apph

584: ,ai.legal_entity_id
585: ,G_SRC_TYP_UNACCT_PREPAY_HIST
586: ,G_SRC_TAB_AP_PREPAY_HIST
587: from ap_invoices_all ai
588: ,ap_prepay_history_all apph
589: ,ap_org_attributes_gt org_gtt
590: where
591: ai.invoice_id = apph.invoice_id
592: -- bug 7311486 UTR report must run even if dates and period is not specified

Line 637: ,ap_prepay_history_all apph

633: ,ai.legal_entity_id
634: ,G_SRC_TYP_UNACCT_PREPAY_HIST
635: ,G_SRC_TAB_AP_PREPAY_HIST
636: from ap_invoices_all ai
637: ,ap_prepay_history_all apph
638: ,ap_org_attributes_gt org_gtt
639: where
640: ai.invoice_id = apph.invoice_id
641: -- bug 7311486 UTR report must run even if dates and period is not specified

Line 852: FROM ap_prepay_history_all apph

848: FROM ap_self_assessed_tax_dist_all aid
849: WHERE aid.bc_event_id = xe.event_id)
850: AND NOT EXISTS
851: (SELECT 1
852: FROM ap_prepay_history_all apph
853: WHERE apph.accounting_event_id = xe.event_id)
854: AND NOT EXISTS
855: (SELECT 1
856: FROM ap_prepay_history_all apph

Line 856: FROM ap_prepay_history_all apph

852: FROM ap_prepay_history_all apph
853: WHERE apph.accounting_event_id = xe.event_id)
854: AND NOT EXISTS
855: (SELECT 1
856: FROM ap_prepay_history_all apph
857: WHERE apph.bc_event_id = xe.event_id)
858: AND NOT EXISTS
859: (SELECT 1
860: FROM ap_invoice_payments_all aip

Line 1945: UPDATE ap_prepay_history_all apph

1941: ltab_id.delete;
1942:
1943: -- gagrawal
1944:
1945: UPDATE ap_prepay_history_all apph
1946: SET accounting_date = g_sweep_to_date,
1947: last_update_date = sysdate,
1948: last_updated_by = 5
1949: WHERE apph.accounting_event_id in (SELECT gt.accounting_event_id

Line 1957: debug ('update_ap_acct_date: total records updated in ap_prepay_history_all: '||sql%rowcount);

1953: AND gt.accounting_event_id IS NOT NULL)
1954: AND apph.posted_flag <> 'Y'
1955: returning apph.accounting_event_id bulk collect into ltab_id;
1956:
1957: debug ('update_ap_acct_date: total records updated in ap_prepay_history_all: '||sql%rowcount);
1958:
1959:
1960: forall i in ltab_id.first .. ltab_id.last
1961: update ap_period_close_excps_gt gt

Line 2048: FROM ap_prepay_history_all apph

2044: FROM ap_self_assessed_tax_dist_all aid
2045: WHERE aid.bc_event_id = xe.event_id)
2046: AND NOT EXISTS
2047: (SELECT 1
2048: FROM ap_prepay_history_all apph
2049: WHERE apph.accounting_event_id = xe.event_id)
2050: AND NOT EXISTS
2051: (SELECT 1
2052: FROM ap_prepay_history_all apph

Line 2052: FROM ap_prepay_history_all apph

2048: FROM ap_prepay_history_all apph
2049: WHERE apph.accounting_event_id = xe.event_id)
2050: AND NOT EXISTS
2051: (SELECT 1
2052: FROM ap_prepay_history_all apph
2053: WHERE apph.bc_event_id = xe.event_id)
2054: AND NOT EXISTS
2055: (SELECT 1
2056: FROM ap_invoice_payments_all aip