DBA Data[Home] [Help]

APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on PO_VENDORS

Line 1286: po_vendors po,

1282:
1283: CURSOR c_get_supplier(c_location_id IN NUMBER) IS
1284: SELECT hz.party_id
1285: FROM hz_parties hz,
1286: po_vendors po,
1287: hz_relationships rel,
1288: hz_party_sites hps,
1289: wsh_locations wl
1290: WHERE wl.wsh_location_id = c_location_id

Line 1297: and rel.subject_table_name = 'PO_VENDORS'

1293: AND rel.relationship_type = 'POS_VENDOR_PARTY'
1294: and rel.object_id = hz.party_id
1295: and rel.object_table_name = 'HZ_PARTIES'
1296: and rel.object_type = 'ORGANIZATION'
1297: and rel.subject_table_name = 'PO_VENDORS'
1298: and rel.subject_id = po.vendor_id
1299: and rel.subject_type = 'POS_VENDOR'
1300: AND hps.party_id = hz.party_id;
1301: