APPS.POS_VIEW_RECEIPTS_GRP dependencies on RCV_SHIPMENT_LINES

Line 94: FROM rcv_shipment_lines

90: IF v_transaction_type = 'RECEIVE' OR v_transaction_type = 'MATCH' THEN
91:
92: /* Find out the item_id for UOM conversion */
93: SELECT item_id INTO X_item_id
94: FROM rcv_shipment_lines
95: WHERE shipment_line_id = v_shipment_line_id;
96:
97: X_received_quantity := v_primary_quantity;
98: X_line_location_id := v_line_location_id;

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:

Line 302: FROM rcv_shipment_lines rsl, po_headers_all ph, po_releases_all pr

298:
299: -- Declare cursor to retrieve the PO number for Supplier View.
300: CURSOR po_cursor(l_shipment_header_id number) IS
301: SELECT DISTINCT(ph.clm_document_number||'-'||pr.release_num), ph.po_header_id, pr.po_release_id
302: FROM rcv_shipment_lines rsl, po_headers_all ph, po_releases_all pr
303: WHERE rsl.shipment_header_id= l_shipment_header_id
304: AND rsl.po_header_id = ph.po_header_id
305: AND rsl.po_release_id = pr.po_release_id
306: AND ph.type_lookup_code = 'BLANKET'

Line 309: FROM rcv_shipment_lines rsl, po_headers_all ph

305: AND rsl.po_release_id = pr.po_release_id
306: AND ph.type_lookup_code = 'BLANKET'
307: UNION ALL
308: SELECT DISTINCT ph.clm_document_number, ph.po_header_id, null
309: FROM rcv_shipment_lines rsl, po_headers_all ph
310: WHERE rsl.shipment_header_id= l_shipment_header_id
311: AND rsl.po_header_id = ph.po_header_id
312: AND ph.type_lookup_code = 'STANDARD';
313: Begin