DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on OE_ORDER_LINES_ALL

Line 2420: FROM oe_order_lines_all a, cs_estimate_details b

2416: WHERE project_id = l_project_id and inventory_organization_id = l_p_ship_from_org_id;
2417:
2418: CURSOR order_line_cu(l_est_detail_id NUMBER) is
2419: SELECT b.order_line_id, a.ship_from_org_id
2420: FROM oe_order_lines_all a, cs_estimate_details b
2421: WHERE a.line_id = b.order_line_id
2422: AND b.estimate_detail_id = l_est_detail_id;
2423:
2424: -- swai: bug 6001057

Line 3386: FROM oe_order_lines_all

3382: SELECT ship_from_org_id, unit_selling_price, org_id
3383: INTO l_ship_from_org_id,
3384: l_unit_selling_price,
3385: l_order_rec.org_id
3386: FROM oe_order_lines_all
3387: WHERE line_id = l_order_line_id;
3388: /*Fixed for bug#5368306
3389: OM does not require sales rep at line to book it.
3390: Depot should not check sales rep at line since oe

Line 4836: from oe_order_lines_all oel,

4832: -- FP for bug fix#9198116: validate the subinventory information
4833: Begin
4834: Select ship_from_org_id, header_id
4835: into l_ship_from_org_id, l_order_header_id
4836: from oe_order_lines_all oel,
4837: cs_estimate_details ced
4838: where oel.line_id = ced.order_line_id
4839: and ced.estimate_detail_id = x_product_txn_rec.estimate_detail_id;
4840: Exception