APPS.JMF_SHIKYU_PO_PVT dependencies on PO_HEADERS_ALL

Line 165: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;

161: l_max_wait NUMBER;
162: l_batch_id NUMBER;
163: l_max_line_location_id NUMBER;
164: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
165: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
166: l_status_flag BOOLEAN;
167:
168: CURSOR c_rec IS
169: SELECT *

Line 185: , po_headers_all poh

181:
182: CURSOR c_po IS
183: SELECT poll.line_location_id
184: FROM po_line_locations_all poll
185: , po_headers_all poh
186: , po_lines_all pol
187: WHERE poll.po_header_id = poh.po_header_id
188: AND poll.po_line_id = pol.po_line_id
189: AND pol.line_reference_num = p_subcontract_po_shipment_id || '-' || l_interface_line_id

Line 191: AND poh.agent_id = l_agent_id /*Bug 7383584 : Added extra where clause to stop FTS on po_headers_all table*/

187: WHERE poll.po_header_id = poh.po_header_id
188: AND poll.po_line_id = pol.po_line_id
189: AND pol.line_reference_num = p_subcontract_po_shipment_id || '-' || l_interface_line_id
190: AND poh.reference_num = p_subcontract_po_shipment_id || '-' || l_interface_header_id
191: AND poh.agent_id = l_agent_id /*Bug 7383584 : Added extra where clause to stop FTS on po_headers_all table*/
192: AND poll.line_location_id > l_max_line_location_id;
193:
194: BEGIN
195:

Line 782: FROM po_headers_all poh

778: /* Log the error in the Concurrent Request log if allocation fails */
779: BEGIN
780: SELECT segment1
781: INTO l_order_number
782: FROM po_headers_all poh
783: WHERE EXISTS
784: (SELECT 1 FROM po_line_locations_all poll
785: WHERE poll.line_location_id = l_subcontract_orders_rec.subcontract_po_shipment_id
786: AND poll.po_header_id = poh.po_header_id);