APPS.EAM_AUTOMATICEST dependencies on PO_REQUISITION_LINES_ALL

Line 285: FROM PO_REQUISITION_LINES_ALL prla , PO_REQUISITION_HEADERS_ALL prha ,

281: nvl( plt.outside_operation_flag, 'N' )
282: INTO l_auth_status , l_dest_type ,
283: l_cancel_flag , l_wip_entity_id ,
284: l_osp
285: FROM PO_REQUISITION_LINES_ALL prla , PO_REQUISITION_HEADERS_ALL prha ,
286: PO_LINE_TYPES plt
287: WHERE prla.requisition_line_id = p_req_line_id
288: AND prla.requisition_header_id = prha.requisition_header_id
289: AND prla.line_type_id = plt.line_type_id;

Line 335: FROM PO_REQUISITION_LINES_ALL

331: l_stmt_num := 70;
332:
333: SELECT quantity , nvl( rate, 0 ) , unit_price
334: INTO l_req_qty_p , l_rate_p , l_unit_price_p
335: FROM PO_REQUISITION_LINES_ALL
336: WHERE requisition_line_id = p_req_line_id
337: AND wip_entity_id = l_wip_entity_id;
338:
339: l_stmt_num := 80;

Line 507: FROM PO_DISTRIBUTIONS_ALL pda , PO_REQUISITION_LINES_ALL prla

503: l_stmt_num := 70;
504:
505: SELECT prla.line_location_id
506: INTO l_line_location_id
507: FROM PO_DISTRIBUTIONS_ALL pda , PO_REQUISITION_LINES_ALL prla
508: WHERE pda.line_location_id = nvl( prla.line_location_id , -999 )
509: AND pda.po_distribution_id = p_po_dist_id ;
510:
511: EXCEPTION