APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_SUPPLIERS

Line 42: child_id AP_SUPPLIERS.vendor_id%type,

38: AND upper(pov.vendor_name)
39: between upper(vendorFrom) and upper(vendorTo);*/
40:
41: TYPE payment_details_rec IS RECORD (
42: child_id AP_SUPPLIERS.vendor_id%type,
43: parent_id AP_SUPPLIERS.parent_vendor_id%type,
44: invoice_id ap_invoices.invoice_id%type,
45: payment_id ap_invoice_payments.invoice_payment_id%type,
46: invoice_payment_amount ap_invoice_payments.amount%type,

Line 43: parent_id AP_SUPPLIERS.parent_vendor_id%type,

39: between upper(vendorFrom) and upper(vendorTo);*/
40:
41: TYPE payment_details_rec IS RECORD (
42: child_id AP_SUPPLIERS.vendor_id%type,
43: parent_id AP_SUPPLIERS.parent_vendor_id%type,
44: invoice_id ap_invoices.invoice_id%type,
45: payment_id ap_invoice_payments.invoice_payment_id%type,
46: invoice_payment_amount ap_invoice_payments.amount%type,
47: discount_amount ap_invoice_payments.discount_taken%type);

Line 64: AP_SUPPLIERS pov,

60: aipa.discount_taken discount_amount
61: FROM ap_invoices aia,
62: ap_invoice_payments aipa,
63: ap_checks aca,
64: AP_SUPPLIERS pov,
65: AP_SUPPLIERS pov1,
66: -- Bug 5647413 Start
67: ap_supplier_sites pvs
68: -- Bug 5647413 End

Line 65: AP_SUPPLIERS pov1,

61: FROM ap_invoices aia,
62: ap_invoice_payments aipa,
63: ap_checks aca,
64: AP_SUPPLIERS pov,
65: AP_SUPPLIERS pov1,
66: -- Bug 5647413 Start
67: ap_supplier_sites pvs
68: -- Bug 5647413 End
69: WHERE aia.invoice_id = aipa.invoice_id

Line 484: from AP_SUPPLIERS pov, IGI_CIS_MTH_RET_PAY_GT pay

480: sum(nvl(pay.TOTAL_DEDUCTIONS, 0)) TOTAL_DEDUCTIONS,
481: sum(nvl(pay.MATERIAL_COST, 0)) MATERIAL_COST,
482: sum(nvl(pay.LABOUR_COST, 0)) LABOUR_COST,
483: sum(nvl(pay.DISCOUNT_AMOUNT, 0)) DISCOUNT_AMOUNT
484: from AP_SUPPLIERS pov, IGI_CIS_MTH_RET_PAY_GT pay
485: where pov.vendor_id = pay.vendor_id
486: group by pov.vendor_id,
487: -- Commented for bug 5671997 and add decode to get partnership name in case BT= partnership
488: -- pov.vendor_name,

Line 530: from AP_SUPPLIERS vendors

526: 0 TOTAL_DEDUCTIONS,
527: 0 MATERIAL_COST,
528: 0 LABOUR_COST,
529: 0 DISCOUNT_AMOUNT
530: from AP_SUPPLIERS vendors
531: where vendors.cis_enabled_flag = 'Y'
532: --And vendor_type_lookup_code in ('PARTNERSHIP','SOLETRADER','COMPANY','TRUST') bug 5620621
533: and vendors.cis_parent_vendor_id is null
534: order by upper(VENDOR_NAME) asc;