APPS.AP_APXWTGNR_XMLP_PKG dependencies on AP_INVOICE_PAYMENTS

Line 790: AP_INVOICE_PAYMENTS AIP,

786: SELECT
787: SUM(AIP.AMOUNT / AI.PAYMENT_CROSS_RATE) AMOUNT,
788: SUM(AIP.PAYMENT_BASE_AMOUNT) BASE_AMOUNT
789: FROM
790: AP_INVOICE_PAYMENTS AIP,
791: AP_INVOICES AI
792: WHERE ( AI.INVOICE_ID = INVOICE_ID_V )
793: AND ( AI.INVOICE_ID = AIP.INVOICE_ID )
794: AND ( AIP.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID

Line 832: AP_INVOICE_PAYMENTS AIP,

828: CURSOR C_DISCOUNT IS
829: SELECT
830: SUM(AIP.DISCOUNT_TAKEN / AI.PAYMENT_CROSS_RATE) DISCOUNT
831: FROM
832: AP_INVOICE_PAYMENTS AIP,
833: AP_INVOICES AI
834: WHERE ( AI.INVOICE_ID = INVOICE_ID_V )
835: AND ( AI.INVOICE_ID = AIP.INVOICE_ID )
836: AND ( AIP.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID

Line 873: AP_INVOICE_PAYMENTS P

869: SELECT
870: C.CHECK_DATE PAYMENT_DATE
871: FROM
872: AP_CHECKS C,
873: AP_INVOICE_PAYMENTS P
874: WHERE ( C.CHECK_ID = P.CHECK_ID )
875: AND ( P.INVOICE_ID = CLASTPAYMENTDATE.INVOICE_ID )
876: AND ( P.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID
877: ,P.INVOICE_PAYMENT_ID) )

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

1110: ' || ' and sub.line_type_lookup_code = ''ITEM''
1111: ' || ' and sub.posted_flag <>''Y'')';
1112: ELSE
1113: RET_TEXT := 'and not exists (select ''Unposted Item''' || '
1114: ' || ' from ap_invoice_payments aip, ' || '
1115: ' || ' ap_payment_history aph ' || '
1116: ' || ' where aip.invoice_id = d.invoice_id' || '
1117: ' || ' and aip.check_id = aph.check_id' || '
1118: ' || ' and (aip.posted_flag <> ''Y''' || '

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

1138: ' || ' and sub.posted_flag <>''Y''' || '
1139: ' || ' )';
1140: ELSE
1141: RET_TEXT := 'and exists (select ''Posted Payment''' || '
1142: ' || ' from ap_invoice_payments aip,' || '
1143: ' || ' ap_payment_history aph' || '
1144: ' || ' where aip.invoice_id = d.invoice_id' || '
1145: ' || ' and aip.check_id = aph.check_id' || '
1146: ' || ' and aip.posted_flag = ''Y''' || '

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

1150: ' || ' from ap_prepay_history aph' || '
1151: ' || ' where aph.invoice_id = d.invoice_id' || '
1152: ' || ' and aph.posted_flag = ''Y'')' || '
1153: ' || ' and exists (select ''Unposted Payment''' || '
1154: ' || ' from ap_invoice_payments aip,' || '
1155: ' || ' ap_payment_history aph' || '
1156: ' || ' where aip.invoice_id = d.invoice_id' || '
1157: ' || ' and aip.check_id = aph.check_id' || '
1158: ' || ' and (aip.posted_flag<>''Y''' || '

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

1172: ' || ' and sub.posted_flag = ''Y''' || '
1173: ' || ' )';
1174: ELSE
1175: RET_TEXT := 'and not exists (select ''Posted Payment''' || '
1176: ' || ' from ap_invoice_payments aip,' || '
1177: ' || ' ap_payment_history aph' || '
1178: ' || ' where aip.invoice_id = d.invoice_id' || '
1179: ' || ' and aip.check_id = aph.check_id' || '
1180: ' || ' and (aip.posted_flag=''Y''' || '

Line 1253: ' || ' from ap_invoice_payments' || ' t_auth_payments' || '

1249: IF ((P_CHECKRUN_NAME IS NOT NULL) AND (P_AWT_REPORT in ('AWT4','AWT5'))) THEN
1250: RET_TEXT := 'and exists' || '
1251: ' || ' (' || '
1252: ' || ' select ''Distribution already paid to ' || 'the tax authority''' || '
1253: ' || ' from ap_invoice_payments' || ' t_auth_payments' || '
1254: ' || ' , ap_checks ' || ' t_auth_checks' || '
1255: ' || ' where t_auth_checks.checkrun_name = ' || ':P_Checkrun_Name' || '
1256: ' || ' and t_auth_checks.check_id = ' || 't_auth_payments.check_id' || '
1257: ' || ' and d.awt_invoice_id = ' || 't_auth_payments.invoice_id' || '

Line 1343: AP_INVOICE_PAYMENTS P

1339: SELECT
1340: C.CHECK_NUMBER PAYMENT_DOC
1341: FROM
1342: AP_CHECKS C,
1343: AP_INVOICE_PAYMENTS P
1344: WHERE ( C.CHECK_ID = P.CHECK_ID )
1345: AND ( P.INVOICE_ID = INVOICE_ID )
1346: AND ( P.INVOICE_PAYMENT_ID = NVL(BREAK_AWT_PAYMENT_ID
1347: ,P.INVOICE_PAYMENT_ID) )