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_IAW_PKG dependencies on STANDARD

Line 4004: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')

4000: ap_invoices_all ai,
4001: wf_local_roles wfr
4002: where ai.invoice_id = l_invoice_id
4003: and ai.invoice_id = ail.invoice_id
4004: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')
4005: and ail.line_type_lookup_code = 'ITEM'
4006: and nvl(ail.disputable_flag, 'N') = 'Y'
4007: and pll.line_location_id = ail.po_line_location_id
4008: and pll.work_approver_id = wfr.orig_system_id

Line 4020: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')

4016: ap_invoices_all ai,
4017: wf_local_roles wfr
4018: where ai.invoice_id = l_invoice_id
4019: and ai.invoice_id = ail.invoice_id
4020: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')
4021: and ail.line_type_lookup_code = 'ITEM'
4022: and nvl(ail.disputable_flag, 'N') = 'Y'
4023: and ail.po_header_id = ph.po_header_id
4024: and ph.agent_id = wfr.orig_system_id

Line 4040: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')

4036: ap_invoices_all ai,
4037: wf_local_roles wfr
4038: where ai.invoice_id = l_invoice_id
4039: and ai.invoice_id = ail.invoice_id
4040: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')
4041: and ail.line_type_lookup_code = 'ITEM'
4042: and nvl(ail.disputable_flag, 'N') = 'Y'
4043: and ail.requester_id = wfr.orig_system_id
4044: and wfr.orig_system = 'PER';

Line 4055: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')

4051: pa_tasks pt,
4052: wf_local_roles wfr
4053: where ai.invoice_id = l_invoice_id
4054: and ai.invoice_id = ail.invoice_id
4055: and ai.invoice_type_lookup_code in ('STANDARD', 'CREDIT', 'PREPAYMENT')
4056: and ail.line_type_lookup_code = 'ITEM'
4057: and nvl(ail.disputable_flag, 'N') = 'Y'
4058: and ail.project_id = pt.project_id
4059: and ail.task_id = pt.task_id

Line 4941: 'INVOICE REQUEST', 'STANDARD',

4937: 'ORG_ID');
4938: update ap_invoices_all
4939: set invoice_type_lookup_code =
4940: decode(invoice_type_lookup_code,
4941: 'INVOICE REQUEST', 'STANDARD',
4942: 'CREDIT MEMO REQUEST', 'CREDIT', 'STANDARD')
4943: where invoice_id = l_invoice_id;
4944:
4945: end;

Line 4942: 'CREDIT MEMO REQUEST', 'CREDIT', 'STANDARD')

4938: update ap_invoices_all
4939: set invoice_type_lookup_code =
4940: decode(invoice_type_lookup_code,
4941: 'INVOICE REQUEST', 'STANDARD',
4942: 'CREDIT MEMO REQUEST', 'CREDIT', 'STANDARD')
4943: where invoice_id = l_invoice_id;
4944:
4945: end;
4946: