APPS.CSTPPINV dependencies on OE_ORDER_LINES_ALL

Line 338: oe_order_lines_all RMA

334: /* Bug 8236035 */
335: SELECT Min(RMA.reference_line_id)
336: INTO l_so_line_id
337: FROM mtl_material_transactions MMT,
338: oe_order_lines_all RMA
339: WHERE MMT.transaction_id = i_txn_id
340: AND RMA.line_id = MMT.trx_source_line_id
341: /* Bug 8236035 */
342: AND EXISTS (SELECT 1

Line 354: oe_order_lines_all SO

350: l_stmt_num := 90;
351: SELECT count(*)
352: INTO l_prior_period_shipment
353: FROM cst_pac_periods cpp,
354: oe_order_lines_all SO
355: WHERE cpp.pac_period_id = i_pac_period_id
356: AND cpp.period_start_date > SO.ACTUAL_SHIPMENT_DATE
357: AND SO.line_id = l_so_line_id;
358: