DBA Data[Home] [Help]

APPS.POS_CREATE_ASN dependencies on PO_LOCATION_ASSOCIATIONS

Line 285: /* We need to join with po_location_associations because

281: ** passed as parameters
282: */
283:
284: -- Get transaction type
285: /* We need to join with po_location_associations because
286: ** if the PO is for OSP and if the WIP job has two
287: ** OSP operations in sequence then we want the first OSP
288: ** vendor to actually ship the goods to the second OSA
289: ** vendor but the receipt and delivery should be recorded

Line 298: from po_location_associations PLA

294: */
295:
296: select count(*)
297: into x_pla_count
298: from po_location_associations PLA
299: where pla.location_id =
300: (select location_id from hr_locations_all
301: where location_code = P_SHIP_TO_LOCATION_CODE_T) and
302: pla.vendor_id is not null and pla.vendor_site_id is not null;