DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on PO_REQUISITION_LINES_ALL

Line 3010: FROM po_requisition_lines_all req,

3006:
3007: -- check how much required
3008: SELECT req.quantity
3009: INTO l_total_req_qty
3010: FROM po_requisition_lines_all req,
3011: oe_order_lines_all ord,
3012: csp_req_line_details csp
3013: WHERE req.requisition_line_id = ord.source_document_line_id
3014: AND ord.line_id = csp.source_id

Line 3214: FROM po_requisition_lines_all

3210: rsl.item_id,
3211: rsl.item_revision AS revision,
3212: rsl.quantity_received AS rcv_qty,
3213: (SELECT quantity
3214: FROM po_requisition_lines_all
3215: WHERE requisition_line_id = oola.source_document_line_id
3216: ) AS ord_qty,
3217: mmt.transaction_uom AS uom,
3218: NVL(crh.need_by_date, sysdate) AS need_by_date,