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_INVOICES_PKG dependencies on AP_INVOICES_ALL

Line 697: FROM ap_invoices_all

693: RELATIONSHIP_ID,
694: /* Bug 7831073 */
695: original_invoice_amount,
696: dispute_reason
697: FROM ap_invoices_all
698: WHERE rowid = X_Rowid
699: FOR UPDATE of Invoice_Id NOWAIT;
700:
701: Recinfo C%ROWTYPE;

Line 1362: FROM ap_invoices_all

1358: RELATIONSHIP_ID,
1359: /* Bug 7831073 */
1360: original_invoice_amount,
1361: dispute_reason
1362: FROM ap_invoices_all
1363: WHERE invoice_id = X_Invoice_id
1364: FOR UPDATE of Invoice_Id NOWAIT;
1365:
1366: Recinfo C%ROWTYPE;

Line 2833: from ap_invoices_all

2829: If l_reapprove>0 then return('REAPPROVE'); end if;
2830:
2831: select wfapproval_status
2832: into header_approval_status
2833: from ap_invoices_all
2834: where invoice_id=p_invoice_id
2835: and org_id=p_org_id;
2836:
2837: IF (l_approved > 0 and header_approval_status = 'NOT REQUIRED') THEN

Line 2998: from ap_invoices_all ai,

2994: sysdate,
2995: 1,
2996: aps.iby_hold_reason,
2997: aps.hold_flag
2998: from ap_invoices_all ai,
2999: ap_payment_schedules_all aps,
3000: ap_suppliers pv,
3001: ap_supplier_sites_all pvs
3002: where ai.invoice_id = p_invoice_id

Line 3016: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;

3012: l_DOCUMENT_PAYABLE_ID number;
3013: l_CALLING_APP_ID number;
3014: l_CALLING_APP_DOC_UNIQUE_REF1 number;
3015: l_CALLING_APP_DOC_UNIQUE_REF2 number;
3016: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;

Line 3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;

3013: l_CALLING_APP_ID number;
3014: l_CALLING_APP_DOC_UNIQUE_REF1 number;
3015: l_CALLING_APP_DOC_UNIQUE_REF2 number;
3016: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;

Line 3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;

3014: l_CALLING_APP_DOC_UNIQUE_REF1 number;
3015: l_CALLING_APP_DOC_UNIQUE_REF2 number;
3016: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3022: l_DOCUMENT_DATE date;

Line 3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;

3016: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3022: l_DOCUMENT_DATE date;
3023: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3024: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;

Line 3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;

3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3022: l_DOCUMENT_DATE date;
3023: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3024: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;
3025: l_DOCUMENT_AMOUNT number;

Line 3023: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;

3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3022: l_DOCUMENT_DATE date;
3023: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3024: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;
3025: l_DOCUMENT_AMOUNT number;
3026: l_EXTERNAL_BANK_ACCOUNT_ID number;
3027: l_PAYEE_PARTY_ID number;

Line 3024: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;

3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3022: l_DOCUMENT_DATE date;
3023: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3024: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;
3025: l_DOCUMENT_AMOUNT number;
3026: l_EXTERNAL_BANK_ACCOUNT_ID number;
3027: l_PAYEE_PARTY_ID number;
3028: l_PAYEE_PARTY_SITE_ID number;

Line 3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;

3029: l_SUPPLIER_SITE_ID number;
3030: l_LEGAL_ENTITY_ID number;
3031: l_ORG_ID number;
3032: l_ORG_TYPE varchar2(30);
3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;

Line 3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;

3030: l_LEGAL_ENTITY_ID number;
3031: l_ORG_ID number;
3032: l_ORG_TYPE varchar2(30);
3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;

Line 3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;

3031: l_ORG_ID number;
3032: l_ORG_TYPE varchar2(30);
3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;

Line 3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;

3032: l_ORG_TYPE varchar2(30);
3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;

Line 3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;

3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;

Line 3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;

3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;

Line 3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;

3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3043: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;
3044: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;
3045: l_DISCOUNT_DATE date;
3046: l_CREATED_BY number;

Line 3043: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;

3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3043: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;
3044: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;
3045: l_DISCOUNT_DATE date;
3046: l_CREATED_BY number;
3047: l_CREATION_DATE date;

Line 3044: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;

3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3043: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;
3044: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;
3045: l_DISCOUNT_DATE date;
3046: l_CREATED_BY number;
3047: l_CREATION_DATE date;
3048: l_LAST_UPDATED_BY number;