DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on OE_ORDER_LINES_ALL

Line 3011: oe_order_lines_all ord,

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
3015: AND csp.source_type = 'IO'

Line 3225: oe_order_lines_all oola,

3221: FROM csp_requirement_headers crh,
3222: csp_requirement_lines crl,
3223: csp_req_line_details crld,
3224: rcv_shipment_lines rsl,
3225: oe_order_lines_all oola,
3226: mtl_material_transactions mmt
3227: WHERE rsl.SHIPMENT_HEADER_ID = l_shipment_header_id
3228: AND rsl.ROUTING_HEADER_ID = -1 -- only direct shipment receive
3229: AND rsl.mmt_transaction_id = mmt.transaction_id