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_APXKIRKI_XMLP_PKG dependencies on AP_PAYMENT_KEY_IND

Line 1369: INSERT INTO AP_PAYMENT_KEY_IND

1365: ,C_NEW_VENDORS_HELD
1366: ,C_UPDATED_VENDORS
1367: ,C_UPDATED_SITES
1368: ,C_ORG_ID);
1369: INSERT INTO AP_PAYMENT_KEY_IND
1370: (PERIOD_NAME
1371: ,LAST_UPDATE_DATE
1372: ,LAST_UPDATED_BY
1373: ,NUM_AUTO_PAYMENTS

Line 1464: AP_PAYMENT_KEY_IND

1460: ,NUM_VENDORS_UPDATED = C_UPDATED_VENDORS
1461: ,NUM_SITES_UPDATED = C_UPDATED_SITES
1462: WHERE PERIOD_NAME = P_PERIOD_NAME;
1463: UPDATE
1464: AP_PAYMENT_KEY_IND
1465: SET
1466: LAST_UPDATE_DATE = SYSDATE
1467: ,LAST_UPDATED_BY = 0
1468: ,NUM_AUTO_PAYMENTS = C_AUTO_PAYMENTS

Line 1592: AP_PAYMENT_KEY_IND PAY

1588: L_OLD_SPOILED,L_OLD_OUTSTANDING,L_OLD_CLEARED,L_OLD_CLEARED_DLR,L_OLD_OUTSTANDING_DLR,L_OLD_REFUND_PAYMENTS,L_OLD_REFUND_PAYMENTS_DLR
1589: FROM
1590: AP_INVOICE_KEY_IND INV,
1591: AP_VENDOR_KEY_IND VEN,
1592: AP_PAYMENT_KEY_IND PAY
1593: WHERE INV.PERIOD_NAME = VEN.PERIOD_NAME
1594: AND INV.PERIOD_NAME = PAY.PERIOD_NAME
1595: AND INV.PERIOD_NAME = C_PRIOR_PERIOD_NAME;
1596: EXCEPTION