APPS.INV_LABEL_PVT3 dependencies on PO_HEADERS_ALL

Line 55: FROM rcv_transactions_interface rti, po_headers_all pha

51: SELECT rti.lpn_id lpn_id
52: , pha.segment1 purchase_order
53: , rti.subinventory
54: , rti.locator_id
55: FROM rcv_transactions_interface rti, po_headers_all pha
56: WHERE rti.interface_transaction_id = p_transaction_id
57: AND rti.po_header_id = pha.po_header_id(+);
58:
59: CURSOR c_rti_lpn_inspection IS

Line 64: FROM rcv_transactions_interface rti, po_headers_all pha

60: SELECT rti.transfer_lpn_id transfer_lpn_id
61: , pha.segment1 purchase_order
62: , rti.subinventory
63: , rti.locator_id
64: FROM rcv_transactions_interface rti, po_headers_all pha
65: WHERE rti.interface_transaction_id = p_transaction_id
66: AND rti.po_header_id = pha.po_header_id(+);
67:
68: CURSOR c_mmtt_lpn IS

Line 274: , po_headers_all pha

270: --AND rt.routing_header_id <> 3
271: AND p_label_type_info.business_flow_code = 1
272: )
273: )) all_lpn
274: , po_headers_all pha
275: , wms_license_plate_numbers wlpn -- Bug 3836623
276: WHERE pha.po_header_id(+) = all_lpn.po_header_id
277: -- Bug 3836623
278: -- Add check for LPN context

Line 440: , po_headers_all pha

436: and rsh.shipment_header_id = p_transaction_id
437: and rsl.asn_lpn_id = lpn.lpn_id
438: AND rsh.asn_type = 'ASN'
439: ) all_lpn
440: , po_headers_all pha
441: , po_lines_all pol
442: , rcv_shipment_headers rsh
443: , po_line_locations_all pll
444: WHERE pha.po_header_id(+) = all_lpn.po_header_id

Line 472: l_purchase_order po_headers_all.segment1%TYPE;

468: l_lpn_id NUMBER;
469: l_content_lpn_id NUMBER;
470: l_transfer_lpn_id NUMBER;
471: l_from_lpn_id NUMBER;
472: l_purchase_order po_headers_all.segment1%TYPE;
473: l_content_item_data LONG;
474: l_selected_fields inv_label.label_field_variable_tbl_type;
475: l_selected_fields_count NUMBER;
476: l_content_rec_index NUMBER := 0;