APPS.AP_APXWTGNR_XMLP_PKG dependencies on AP_INVOICE_PAYMENTS

Line 780: AP_INVOICE_PAYMENTS AIP,

776: SELECT
777: SUM(AIP.AMOUNT / AI.PAYMENT_CROSS_RATE) AMOUNT,
778: SUM(AIP.PAYMENT_BASE_AMOUNT) BASE_AMOUNT
779: FROM
780: AP_INVOICE_PAYMENTS AIP,
781: AP_INVOICES AI
782: WHERE ( AI.INVOICE_ID = INVOICE_ID_V )
783: AND ( AI.INVOICE_ID = AIP.INVOICE_ID )
784: AND ( AIP.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID

Line 822: AP_INVOICE_PAYMENTS AIP,

818: CURSOR C_DISCOUNT IS
819: SELECT
820: SUM(AIP.DISCOUNT_TAKEN / AI.PAYMENT_CROSS_RATE) DISCOUNT
821: FROM
822: AP_INVOICE_PAYMENTS AIP,
823: AP_INVOICES AI
824: WHERE ( AI.INVOICE_ID = INVOICE_ID_V )
825: AND ( AI.INVOICE_ID = AIP.INVOICE_ID )
826: AND ( AIP.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID

Line 863: AP_INVOICE_PAYMENTS P

859: SELECT
860: C.CHECK_DATE PAYMENT_DATE
861: FROM
862: AP_CHECKS C,
863: AP_INVOICE_PAYMENTS P
864: WHERE ( C.CHECK_ID = P.CHECK_ID )
865: AND ( P.INVOICE_ID = CLASTPAYMENTDATE.INVOICE_ID )
866: AND ( P.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID
867: ,P.INVOICE_PAYMENT_ID) )

Line 1104: ' || ' from ap_invoice_payments aip, ' || '

1100: ' || ' and sub.line_type_lookup_code = ''ITEM''
1101: ' || ' and sub.posted_flag <>''Y'')';
1102: ELSE
1103: RET_TEXT := 'and not exists (select ''Unposted Item''' || '
1104: ' || ' from ap_invoice_payments aip, ' || '
1105: ' || ' ap_payment_history aph ' || '
1106: ' || ' where aip.invoice_id = d.invoice_id' || '
1107: ' || ' and aip.check_id = aph.check_id' || '
1108: ' || ' and (aip.posted_flag <> ''Y''' || '

Line 1132: ' || ' from ap_invoice_payments aip,' || '

1128: ' || ' and sub.posted_flag <>''Y''' || '
1129: ' || ' )';
1130: ELSE
1131: RET_TEXT := 'and exists (select ''Posted Payment''' || '
1132: ' || ' from ap_invoice_payments aip,' || '
1133: ' || ' ap_payment_history aph' || '
1134: ' || ' where aip.invoice_id = d.invoice_id' || '
1135: ' || ' and aip.check_id = aph.check_id' || '
1136: ' || ' and aip.posted_flag = ''Y''' || '

Line 1144: ' || ' from ap_invoice_payments aip,' || '

1140: ' || ' from ap_prepay_history aph' || '
1141: ' || ' where aph.invoice_id = d.invoice_id' || '
1142: ' || ' and aph.posted_flag = ''Y'')' || '
1143: ' || ' and exists (select ''Unposted Payment''' || '
1144: ' || ' from ap_invoice_payments aip,' || '
1145: ' || ' ap_payment_history aph' || '
1146: ' || ' where aip.invoice_id = d.invoice_id' || '
1147: ' || ' and aip.check_id = aph.check_id' || '
1148: ' || ' and (aip.posted_flag<>''Y''' || '

Line 1166: ' || ' from ap_invoice_payments aip,' || '

1162: ' || ' and sub.posted_flag = ''Y''' || '
1163: ' || ' )';
1164: ELSE
1165: RET_TEXT := 'and not exists (select ''Posted Payment''' || '
1166: ' || ' from ap_invoice_payments aip,' || '
1167: ' || ' ap_payment_history aph' || '
1168: ' || ' where aip.invoice_id = d.invoice_id' || '
1169: ' || ' and aip.check_id = aph.check_id' || '
1170: ' || ' and (aip.posted_flag=''Y''' || '

Line 1243: ' || ' from ap_invoice_payments' || ' t_auth_payments' || '

1239: IF ((P_CHECKRUN_NAME IS NOT NULL) AND (P_AWT_REPORT in ('AWT4','AWT5'))) THEN
1240: RET_TEXT := 'and exists' || '
1241: ' || ' (' || '
1242: ' || ' select ''Distribution already paid to ' || 'the tax authority''' || '
1243: ' || ' from ap_invoice_payments' || ' t_auth_payments' || '
1244: ' || ' , ap_checks ' || ' t_auth_checks' || '
1245: ' || ' where t_auth_checks.checkrun_name = ' || ':P_Checkrun_Name' || '
1246: ' || ' and t_auth_checks.check_id = ' || 't_auth_payments.check_id' || '
1247: ' || ' and d.awt_invoice_id = ' || 't_auth_payments.invoice_id' || '

Line 1333: AP_INVOICE_PAYMENTS P

1329: SELECT
1330: C.CHECK_NUMBER PAYMENT_DOC
1331: FROM
1332: AP_CHECKS C,
1333: AP_INVOICE_PAYMENTS P
1334: WHERE ( C.CHECK_ID = P.CHECK_ID )
1335: AND ( P.INVOICE_ID = INVOICE_ID )
1336: AND ( P.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID
1337: ,P.INVOICE_PAYMENT_ID) )