APPS.INV_UI_ITEM_ATT_LOVS dependencies on RCV_SHIPMENT_LINES

Line 169: l_source_document_code rcv_shipment_lines.source_document_code%TYPE;

165: ) IS
166: l_src_org_lot_ctrl NUMBER := 1;
167: l_rcv_org_lot_ctrl NUMBER := 1;
168: l_src_org_srl_ctrl NUMBER := 1;
169: l_source_document_code rcv_shipment_lines.source_document_code%TYPE;
170: BEGIN
171:
172: BEGIN
173: --Get the lot control in source and receiving orgs and the

Line 185: , rcv_shipment_lines rsl

181: , l_rcv_org_lot_ctrl
182: , l_source_document_code
183: FROM mtl_system_items msi1
184: , mtl_system_items msi2
185: , rcv_shipment_lines rsl
186: WHERE rsl.shipment_header_id = p_shipment_header_id
187: AND rsl.to_organization_id = p_organization_id
188: AND rsl.item_id = p_item_id
189: AND msi1.inventory_item_id = p_item_id

Line 220: , rcv_shipment_lines rsl

216: , 0
217: , msn.current_status
218: , mms.status_code
219: FROM rcv_serials_supply rss
220: , rcv_shipment_lines rsl
221: , mtl_serial_numbers msn
222: , mtl_material_statuses_tl mms
223: WHERE rss.shipment_line_id(+) = rsl.shipment_line_id
224: --BUG 3417870: The RSL.shipment_line_status_code will be FULLY

Line 271: , rcv_shipment_lines rsl

267: , 0
268: , msn.current_status
269: , mms.status_code
270: FROM mtl_serial_numbers msn
271: , rcv_shipment_lines rsl
272: , mtl_material_statuses_tl mms
273: WHERE msn.inventory_item_id = p_item_id
274: AND rsl.shipment_header_id = p_shipment_header_id
275: AND (msn.group_mark_id IS NULL OR msn.group_mark_id = -1)

Line 3952: , rcv_shipment_lines rsl

3948: , 0
3949: , current_status
3950: , mms.status_code
3951: FROM rcv_serials_supply rss
3952: , rcv_shipment_lines rsl
3953: , mtl_serial_numbers msn
3954: , mtl_material_statuses_tl mms
3955: WHERE rss.shipment_line_id(+) = rsl.shipment_line_id
3956: AND nvl(rss.supply_type_code, 'SHIPMENT') = 'SHIPMENT'