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_CHECKS_ALL

Line 634: ap_checks_all ac,

630: ac.vendor_id
631: ,G_SRC_TYP_UNACCT_PMT_HISTORY
632: ,G_SRC_TAB_AP_PMT_HISTORY
633: FROM ap_payment_history_all aph,
634: ap_checks_all ac,
635: ap_org_attributes_gt orgs
636: WHERE aph.posted_flag IN ('N','S')
637: AND ac.check_id = aph.check_id
638: and (aph.accounting_date between g_period_start_date and g_period_end_date)

Line 704: ap_checks_All ac,

700: ac.vendor_id
701: ,G_SRC_TYP_UNACCT_INV_PMTS
702: ,G_SRC_TAB_AP_INV_PAYMENTS
703: FROM ap_invoice_payments_all aip,
704: ap_checks_All ac,
705: ap_org_attributes_gt orgs
706: WHERE aip.posted_flag IN ('N','S')
707: and (aip.accounting_date between g_period_start_date and g_period_end_date)
708: AND aip.org_id = orgs.org_id

Line 804: select party_id from ap_checks_all

800: ,(select party_id from ap_invoices_all
801: where invoice_id = xla_headers_untransfered(i).source_id_int_1
802: and 'AP_INVOICES' = xla_headers_untransfered(i).entity_code
803: union
804: select party_id from ap_checks_all
805: where check_id = xla_headers_untransfered(i).source_id_int_1
806: and 'AP_PAYMENTS' = xla_headers_untransfered(i).entity_code) /*Bug 9721897*/
807: ,(select vendor_id from ap_invoices_all
808: where invoice_id = xla_headers_untransfered(i).source_id_int_1

Line 811: select vendor_id from ap_checks_all

807: ,(select vendor_id from ap_invoices_all
808: where invoice_id = xla_headers_untransfered(i).source_id_int_1
809: and 'AP_INVOICES' = xla_headers_untransfered(i).entity_code
810: union
811: select vendor_id from ap_checks_all
812: where check_id = xla_headers_untransfered(i).source_id_int_1
813: and 'AP_PAYMENTS' = xla_headers_untransfered(i).entity_code) /*Bug 9721897*/
814: );
815:

Line 1014: ap_checks_all ac,

1010: ,xla_events_unacct(i).entity_code
1011: ,G_SRC_TYP_OTHER_EXCPS
1012: ,G_SRC_TAB_AP_PMT_HISTORY
1013: FROM ap_payment_history_all aph,
1014: ap_checks_all ac,
1015: ap_org_attributes_gt orgs
1016: WHERE aph.check_id = ac.check_id(+)
1017: AND aph.org_id = orgs.org_id
1018: AND ( NVL(orgs.when_to_account_pmt, 'ALWAYS') = 'ALWAYS' or

Line 1078: select party_id from ap_checks_all

1074: ,(select party_id from ap_invoices_all
1075: where invoice_id = xla_events_unacct(i).source_id_int_1
1076: and 'AP_INVOICES' = xla_events_unacct(i).entity_code
1077: union
1078: select party_id from ap_checks_all
1079: where check_id = xla_events_unacct(i).source_id_int_1
1080: and 'AP_PAYMENTS' = xla_events_unacct(i).entity_code) party_id /*Bug 9721897*/
1081: ,(select vendor_id from ap_invoices_all
1082: where invoice_id = xla_events_unacct(i).source_id_int_1

Line 1085: select vendor_id from ap_checks_all

1081: ,(select vendor_id from ap_invoices_all
1082: where invoice_id = xla_events_unacct(i).source_id_int_1
1083: and 'AP_INVOICES' = xla_events_unacct(i).entity_code
1084: union
1085: select vendor_id from ap_checks_all
1086: where check_id = xla_events_unacct(i).source_id_int_1
1087: and 'AP_PAYMENTS' = xla_events_unacct(i).entity_code) vendor_id /*Bug 9721897*/
1088: FROM DUAL
1089: where xla_events_unacct(i).security_id_int_1 in (Select org_id

Line 1235: from ap_checks_all c

1231: -- check if any unmatured future payments exists
1232: cursor c_unmat_fut_pmts_exists
1233: is
1234: select 'Y'
1235: from ap_checks_all c
1236: where c.future_pay_due_date is not null
1237: and c.status_lookup_code = 'ISSUED'
1238: and c.future_pay_due_date between g_period_start_date
1239: and g_period_end_date

Line 1622: l_check_id AP_CHECKS_ALL.Check_Id%TYPE;

1618: /* Modified the procedure for bug 7137359, related to AWT event creation */
1619: l_invoice_num VARCHAR2(50);
1620: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
1621: l_count NUMBER(15);
1622: l_check_id AP_CHECKS_ALL.Check_Id%TYPE;
1623: l_check_number AP_CHECKS_ALL.Check_Number%TYPE;
1624:
1625: BEGIN
1626:

Line 1623: l_check_number AP_CHECKS_ALL.Check_Number%TYPE;

1619: l_invoice_num VARCHAR2(50);
1620: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
1621: l_count NUMBER(15);
1622: l_check_id AP_CHECKS_ALL.Check_Id%TYPE;
1623: l_check_number AP_CHECKS_ALL.Check_Number%TYPE;
1624:
1625: BEGIN
1626:
1627: l_event_source_info.application_id := G_AP_APPLICATION_ID;

Line 1647: ap_checks_all ac

1643: select DISTINCT ac.check_id, --bug9649978
1644: ac.check_number
1645: into l_check_id, l_check_number
1646: from ap_invoice_payments_all aip,
1647: ap_checks_all ac
1648: where aip.check_id=ac.check_id
1649: and aip.accounting_event_id = p_event_id
1650: and aip.invoice_id= p_trans_id;
1651: