APPS.AP_APXKIRKI_XMLP_PKG dependencies on PO_VENDORS

Line 451: PO_VENDORS

447: ,1))
448: ,0)
449: INTO L_TOTAL_VENDORS,L_TOTAL_INACTIVE,L_TOTAL_ONE_TIME,L_TOTAL_1099
450: FROM
451: PO_VENDORS
452: WHERE TRUNC(CREATION_DATE) <= TO_DATE(C_END_DATE
453: ,'DD/MM/YYYY');
454: SELECT
455: count(*)

Line 656: PO_VENDORS PV,

652: SELECT
653: count(*)
654: INTO L_TOTAL_SITES
655: FROM
656: PO_VENDORS PV,
657: PO_VENDOR_SITES PVS
658: WHERE TRUNC(PVS.CREATION_DATE) <= TO_DATE(C_END_DATE
659: ,'DD/MM/YYYY')
660: AND PV.VENDOR_ID = PVS.VENDOR_ID

Line 1187: PO_VENDORS

1183: ,1))
1184: ,0)
1185: INTO L_NEW_VENDORS,L_NEW_INACTIVE,L_NEW_ONE_TIME,L_NEW_TYPE_1099_VENDORS
1186: FROM
1187: PO_VENDORS
1188: WHERE TRUNC(CREATION_DATE) >= TO_DATE(C_START_DATE
1189: ,'DD/MM/YYYY')
1190: AND TRUNC(CREATION_DATE) <= TO_DATE(C_END_DATE
1191: ,'DD/MM/YYYY');

Line 1204: PO_VENDORS PV,

1200: ,0)))
1201: ,0)
1202: INTO L_OLD_VENDOR_SITES,L_TOTAL_VENDORS_HELD
1203: FROM
1204: PO_VENDORS PV,
1205: PO_VENDOR_SITES PVS
1206: WHERE TRUNC(PVS.CREATION_DATE) >= TO_DATE(C_START_DATE
1207: ,'DD/MM/YYYY')
1208: AND TRUNC(PVS.CREATION_DATE) <= TO_DATE(C_END_DATE

Line 1225: PO_VENDORS PV,

1221: ,0)))
1222: ,0)
1223: INTO L_NEW_VENDOR_SITES,L_NEW_VENDORS_HELD
1224: FROM
1225: PO_VENDORS PV,
1226: PO_VENDOR_SITES PVS
1227: WHERE TRUNC(PVS.CREATION_DATE) >= TO_DATE(C_START_DATE
1228: ,'DD/MM/YYYY')
1229: AND TRUNC(PVS.CREATION_DATE) <= TO_DATE(C_END_DATE

Line 1240: PO_VENDORS

1236: SELECT
1237: count(*)
1238: INTO L_UPDATED_VENDORS
1239: FROM
1240: PO_VENDORS
1241: WHERE TRUNC(LAST_UPDATE_DATE) >= TO_DATE(C_START_DATE
1242: ,'DD/MM/YYYY')
1243: AND TRUNC(LAST_UPDATE_DATE) <= TO_DATE(C_END_DATE
1244: ,'DD/MM/YYYY');