APPS.AP_1099_UTILITIES_PKG dependencies on PO_VENDOR_SITES

Line 907: po_vendor_sites pvs

903: pvs.city CITY,
904: pvs.zip ZIP,
905: pvs.COUNTRY COUNTRY
906: FROM po_vendors P,
907: po_vendor_sites pvs
908: WHERE pvs.vendor_id = P.vendor_id
909: AND nvl(p.vendor_type_lookup_code, 'DUMMY') <> 'EMPLOYEE' /*Bug 9247826*/
910: AND (NVL(pvs.tax_reporting_site_flag,'N') = 'Y' OR
911: (pvs.vendor_site_code =

Line 913: from po_vendor_sites pvs2

909: AND nvl(p.vendor_type_lookup_code, 'DUMMY') <> 'EMPLOYEE' /*Bug 9247826*/
910: AND (NVL(pvs.tax_reporting_site_flag,'N') = 'Y' OR
911: (pvs.vendor_site_code =
912: (select min(vendor_site_code)
913: from po_vendor_sites pvs2
914: where pvs2.vendor_id = pvs.vendor_id
915: and nvl(inactive_date, sysdate + 9000) =
916: (select max(decode(inactive_date,
917: '',

Line 920: from po_vendor_sites pvs3

916: (select max(decode(inactive_date,
917: '',
918: sysdate + 9000,
919: inactive_date))
920: from po_vendor_sites pvs3
921: where pvs3.vendor_id = pvs.vendor_id))
922: AND not exists
923: (SELECT 'A tax reporting site exists for this vendor'
924: FROM po_vendor_sites pvs4

Line 924: FROM po_vendor_sites pvs4

920: from po_vendor_sites pvs3
921: where pvs3.vendor_id = pvs.vendor_id))
922: AND not exists
923: (SELECT 'A tax reporting site exists for this vendor'
924: FROM po_vendor_sites pvs4
925: WHERE NVL(pvs4.tax_reporting_site_flag,'N') = 'Y'
926: AND pvs4.vendor_id = pvs.vendor_id)))
927: UNION ALL
928: SELECT distinct PV.vendor_id VENDOR_ID,

Line 1064: PO_VENDOR_SITES pvs,

1060: WHERE NVL(papf1.effective_end_date,sysdate +9000) =
1061: (SELECT MAX(DECODE(papf2.effective_end_date,'',sysdate+9000,papf2.effective_end_date))
1062: FROM PER_ALL_PEOPLE_F papf2
1063: WHERE papf1.person_id=papf2.person_id)) papf,
1064: PO_VENDOR_SITES pvs,
1065: PO_VENDORS pv
1066: WHERE pv.employee_id = papf.person_id
1067: AND nvl(pv.vendor_type_lookup_code, 'DUMMY') = 'EMPLOYEE' /*Bug 9247826*/
1068: AND pv.vendor_id = pvs.vendor_id

Line 1086: from po_vendor_sites pvs2

1082: per_assgn.effective_end_date(+))
1083: AND (NVL(pvs.tax_reporting_site_flag,'N') = 'Y' OR
1084: (pvs.vendor_site_code =
1085: (select min(vendor_site_code)
1086: from po_vendor_sites pvs2
1087: where pvs2.vendor_id = pvs.vendor_id
1088: and nvl(inactive_date, sysdate + 9000) =
1089: (select max(decode(inactive_date,
1090: '',

Line 1093: from po_vendor_sites pvs3

1089: (select max(decode(inactive_date,
1090: '',
1091: sysdate + 9000,
1092: inactive_date))
1093: from po_vendor_sites pvs3
1094: where pvs3.vendor_id = pvs.vendor_id)) AND not exists
1095: (SELECT 'A tax reporting site exists for this vendor'
1096: FROM po_vendor_sites pvs4
1097: WHERE NVL(pvs4.tax_reporting_site_flag,'N') = 'Y'

Line 1096: FROM po_vendor_sites pvs4

1092: inactive_date))
1093: from po_vendor_sites pvs3
1094: where pvs3.vendor_id = pvs.vendor_id)) AND not exists
1095: (SELECT 'A tax reporting site exists for this vendor'
1096: FROM po_vendor_sites pvs4
1097: WHERE NVL(pvs4.tax_reporting_site_flag,'N') = 'Y'
1098: AND pvs4.vendor_id = pvs.vendor_id)))) pvw /*Bug 8768541 :added the inline view for emp address from HR*/
1099: where pvw.vendor_id = TD.vendor_id
1100: GROUP BY pvw.vendor_name,