DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PUB dependencies on PO_VENDORS

Line 6295: 'PO_VENDORS',

6291: 'EMPLOYEE',
6292: (SELECT employee_id FROM per_employees_current_x
6293: WHERE employee_num = cws.OWNER_PARTY_NUM
6294: AND full_name = cws.OWNER_NAME),
6295: 'PO_VENDORS',
6296: (SELECT vendor_id FROM po_vendors WHERE segment1 = cws.OWNER_PARTY_NUM
6297: AND vendor_name = cws.OWNER_NAME
6298: AND nvl(start_date_active,sysdate) <= sysdate AND nvl(end_date_Active, sysdate+1) > SYSDATE
6299: AND enabled_flag = 'Y'),

Line 6296: (SELECT vendor_id FROM po_vendors WHERE segment1 = cws.OWNER_PARTY_NUM

6292: (SELECT employee_id FROM per_employees_current_x
6293: WHERE employee_num = cws.OWNER_PARTY_NUM
6294: AND full_name = cws.OWNER_NAME),
6295: 'PO_VENDORS',
6296: (SELECT vendor_id FROM po_vendors WHERE segment1 = cws.OWNER_PARTY_NUM
6297: AND vendor_name = cws.OWNER_NAME
6298: AND nvl(start_date_active,sysdate) <= sysdate AND nvl(end_date_Active, sysdate+1) > SYSDATE
6299: AND enabled_flag = 'Y'),
6300: null)

Line 6324: 'PO_VENDORS',

6320: 'EMPLOYEE',
6321: (SELECT employee_id FROM per_employees_current_x
6322: WHERE employee_num = cws.ASSOCIATE_BILL_TO_PARTY_NUMBER
6323: AND full_name = cws.ASSOCIATE_BILL_TO_PARTY_NAME),
6324: 'PO_VENDORS',
6325: (SELECT vendor_id FROM po_vendors
6326: WHERE segment1 = cws.ASSOCIATE_BILL_TO_PARTY_NUMBER
6327: AND vendor_name = cws.ASSOCIATE_BILL_TO_PARTY_NAME
6328: AND nvl(start_date_active,sysdate) <= sysdate AND nvl(end_date_Active, sysdate+1) > SYSDATE

Line 6325: (SELECT vendor_id FROM po_vendors

6321: (SELECT employee_id FROM per_employees_current_x
6322: WHERE employee_num = cws.ASSOCIATE_BILL_TO_PARTY_NUMBER
6323: AND full_name = cws.ASSOCIATE_BILL_TO_PARTY_NAME),
6324: 'PO_VENDORS',
6325: (SELECT vendor_id FROM po_vendors
6326: WHERE segment1 = cws.ASSOCIATE_BILL_TO_PARTY_NUMBER
6327: AND vendor_name = cws.ASSOCIATE_BILL_TO_PARTY_NAME
6328: AND nvl(start_date_active,sysdate) <= sysdate AND nvl(end_date_Active, sysdate+1) > SYSDATE
6329: AND enabled_flag = 'Y'),

Line 6354: 'PO_VENDORS',

6350: 'EMPLOYEE',
6351: (SELECT employee_id FROM per_employees_current_x
6352: WHERE employee_num = cws.ASSOCIATE_SHIP_TO_PARTY_NUMBER
6353: AND full_name = cws.ASSOCIATE_SHIP_TO_PARTY_NAME),
6354: 'PO_VENDORS',
6355: (SELECT vendor_id FROM po_vendors
6356: WHERE segment1 = cws.ASSOCIATE_SHIP_TO_PARTY_NUMBER
6357: AND vendor_name = cws.ASSOCIATE_SHIP_TO_PARTY_NAME
6358: AND nvl(start_date_active,sysdate) <= sysdate AND nvl(end_date_Active, sysdate+1) > SYSDATE

Line 6355: (SELECT vendor_id FROM po_vendors

6351: (SELECT employee_id FROM per_employees_current_x
6352: WHERE employee_num = cws.ASSOCIATE_SHIP_TO_PARTY_NUMBER
6353: AND full_name = cws.ASSOCIATE_SHIP_TO_PARTY_NAME),
6354: 'PO_VENDORS',
6355: (SELECT vendor_id FROM po_vendors
6356: WHERE segment1 = cws.ASSOCIATE_SHIP_TO_PARTY_NUMBER
6357: AND vendor_name = cws.ASSOCIATE_SHIP_TO_PARTY_NAME
6358: AND nvl(start_date_active,sysdate) <= sysdate AND nvl(end_date_Active, sysdate+1) > SYSDATE
6359: AND enabled_flag = 'Y'),