DBA Data[Home] [Help]

APPS.POS_VIEW_RECEIPTS_GRP dependencies on MTL_SYSTEM_ITEMS

Line 269: FROM mtl_system_items msi, rcv_shipment_lines rsl

265:
266: /* No LPN; Find the lot or serial defined for this item */
267:
268: SELECT lot_control_code, serial_number_control_code into isLot, isSerial
269: FROM mtl_system_items msi, rcv_shipment_lines rsl
270: WHERE msi.organization_id = rsl.to_organization_id
271: AND msi.inventory_item_id = rsl.item_id
272: AND rsl.shipment_line_id = p_rcv_shipment_line_id;
273: