DBA Data[Home] [Help]

APPS.CSTPPINV dependencies on OE_ORDER_LINES_ALL

Line 337: oe_order_lines_all RMA

333: l_stmt_num := 74;
334: SELECT RMA.reference_line_id
335: INTO l_so_line_id
336: FROM mtl_material_transactions MMT,
337: oe_order_lines_all RMA
338: WHERE MMT.transaction_id = i_txn_id
339: AND RMA.line_id = MMT.trx_source_line_id;
340:
341: -- If the RMA references a sales order issue, and if the

Line 348: oe_order_lines_all SO

344: l_stmt_num := 75;
345: SELECT count(*)
346: INTO l_prior_period_shipment
347: FROM cst_pac_periods cpp,
348: oe_order_lines_all SO
349: WHERE cpp.pac_period_id = i_pac_period_id
350: AND cpp.period_start_date > SO.ACTUAL_SHIPMENT_DATE
351: AND SO.line_id = l_so_line_id;
352: