DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG6 dependencies on OE_ORDER_LINES_ALL

Line 156: FROM oe_order_lines_all oel,

152:
153: -- Cursor to get om rma org id
154: CURSOR c_get_om_rma_org_id (p_repair_line_id in number) IS
155: SELECT oel.ship_from_org_id
156: FROM oe_order_lines_all oel,
157: csd_repairs cr
158: WHERE
159: cr.repair_line_id = p_repair_line_id
160: AND cr.original_source_header_id = oel.header_id

Line 166: FROM oe_order_lines_all oel,

162:
163: -- Cursor to get ro rma org id
164: CURSOR c_get_ro_rma_org_id (p_repair_line_id in number) IS
165: SELECT oel.ship_from_org_Id
166: FROM oe_order_lines_all oel,
167: csd_product_transactions cp
168: WHERE cp.repair_line_id = p_repair_line_Id
169: AND cp.action_type in ('RMA','MOVE_IN')
170: AND cp.order_line_id = oel.line_id