DBA Data[Home] [Help]

APPS.RCV_AVAILABILITY dependencies on PO_REQUISITION_LINES_ALL

Line 129: FROM po_requisition_lines_all rl,

125: SELECT rl.quantity,
126: rl.item_id,
127: rl.unit_meas_lookup_code unit_of_measure,
128: si.primary_unit_of_measure
129: FROM po_requisition_lines_all rl,
130: mtl_system_items si
131: WHERE rl.requisition_line_id = p_supply_demand_line_id
132: AND si.inventory_item_id(+) = rl.item_id;
133:

Line 900: FROM po_requisition_lines_all rl,

896: * Change all the table to base tables.
897: */
898: SELECT 'Y'
899: INTO x_valid_status
900: FROM po_requisition_lines_all rl,
901: po_requisition_headers_all rh
902: WHERE rh.requisition_header_id = rl.requisition_header_id
903: AND type_lookup_code = l_lookup_code
904: AND authorization_status = 'APPROVED'