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.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_SUPPLIERS

Line 77: child_id AP_SUPPLIERS.vendor_id%type,

73: AND upper(pov.vendor_name)
74: between upper(vendorFrom) and upper(vendorTo);*/
75:
76: TYPE payment_details_rec IS RECORD (
77: child_id AP_SUPPLIERS.vendor_id%type,
78: parent_id AP_SUPPLIERS.parent_vendor_id%type,
79: invoice_id ap_invoices.invoice_id%type,
80: payment_id ap_invoice_payments.invoice_payment_id%type,
81: invoice_payment_amount ap_invoice_payments.amount%type,

Line 78: parent_id AP_SUPPLIERS.parent_vendor_id%type,

74: between upper(vendorFrom) and upper(vendorTo);*/
75:
76: TYPE payment_details_rec IS RECORD (
77: child_id AP_SUPPLIERS.vendor_id%type,
78: parent_id AP_SUPPLIERS.parent_vendor_id%type,
79: invoice_id ap_invoices.invoice_id%type,
80: payment_id ap_invoice_payments.invoice_payment_id%type,
81: invoice_payment_amount ap_invoice_payments.amount%type,
82: discount_amount ap_invoice_payments.discount_taken%type);

Line 100: AP_SUPPLIERS pov,

96: aipa.discount_taken discount_amount
97: FROM ap_invoices aia,
98: ap_invoice_payments aipa,
99: ap_checks aca,
100: AP_SUPPLIERS pov,
101: AP_SUPPLIERS pov1,
102: -- Bug 5647413 Start
103: ap_supplier_sites pvs
104: -- Bug 5647413 End

Line 101: AP_SUPPLIERS pov1,

97: FROM ap_invoices aia,
98: ap_invoice_payments aipa,
99: ap_checks aca,
100: AP_SUPPLIERS pov,
101: AP_SUPPLIERS pov1,
102: -- Bug 5647413 Start
103: ap_supplier_sites pvs
104: -- Bug 5647413 End
105: WHERE aia.invoice_id = aipa.invoice_id

Line 703: from AP_SUPPLIERS pov, IGI_CIS_MTH_RET_PAY_GT pay

699: sum(nvl(pay.MATERIAL_COST, 0)) MATERIAL_COST,
700: sum(nvl(pay.LABOUR_COST, 0)) LABOUR_COST,
701: sum(nvl(pay.DISCOUNT_AMOUNT, 0)) DISCOUNT_AMOUNT,
702: sum(nvl(pay.CIS_TAX,0)) CIS_TAX
703: from AP_SUPPLIERS pov, IGI_CIS_MTH_RET_PAY_GT pay
704: where pov.vendor_id = pay.vendor_id
705: group by pov.vendor_id,
706: -- Commented for bug 5671997 and add decode to get partnership name in case BT= partnership
707: -- pov.vendor_name,

Line 750: from AP_SUPPLIERS vendors

746: 0 MATERIAL_COST,
747: 0 LABOUR_COST,
748: 0 DISCOUNT_AMOUNT,
749: 0 CIS_TAX
750: from AP_SUPPLIERS vendors
751: where vendors.cis_enabled_flag = 'Y'
752: --And vendor_type_lookup_code in ('PARTNERSHIP','SOLETRADER','COMPANY','TRUST') bug 5620621
753: and vendors.cis_parent_vendor_id is null
754: order by upper(VENDOR_NAME) asc;