DBA Data[Home] [Help]

APPS.RCV_AVAILABILITY dependencies on PO_REQUISITION_LINES_ALL

Line 153: FROM po_requisition_lines_all rl,

149: SELECT rl.quantity,
150: rl.item_id,
151: rl.unit_meas_lookup_code unit_of_measure,
152: si.primary_unit_of_measure
153: FROM po_requisition_lines_all rl,
154: mtl_system_items si
155: WHERE rl.requisition_line_id = p_supply_demand_line_id
156: AND si.inventory_item_id(+) = rl.item_id;
157:

Line 994: FROM po_requisition_lines_all rl,

990: * Change all the table to base tables.
991: */
992: SELECT 'Y'
993: INTO x_valid_status
994: FROM po_requisition_lines_all rl,
995: po_requisition_headers_all rh
996: WHERE rh.requisition_header_id = rl.requisition_header_id
997: AND type_lookup_code = l_lookup_code
998: AND authorization_status = 'APPROVED'