DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG3 dependencies on OE_ORDER_LINES_ALL

Line 3382: oe_order_lines_all oola ,

3378: csd_repairs cr ,
3379: csd_repair_types_b crt,
3380: cs_estimate_details ced ,
3381: oe_order_headers_all ooha,
3382: oe_order_lines_all oola ,
3383: mtl_system_items_b msi
3384: Where cpt.product_transaction_id >= p_Start_Slab
3385: and cpt.product_transaction_id <= p_End_Slab
3386: and cpt.repair_line_id = cr.repair_line_id

Line 3408: and rcvt.oe_order_line_id in ( Select line_id from oe_order_lines_all

3404: Select rcvt.transaction_id, rcvt.quantity, rcvt.locator_id
3405: From Rcv_Transactions Rcvt
3406: Where rcvt.Transaction_Type = 'DELIVER'
3407: and rcvt.oe_order_header_id = p_order_header_Id
3408: and rcvt.oe_order_line_id in ( Select line_id from oe_order_lines_all
3409: start with line_id = p_Order_Line_Id
3410: connect by prior line_id = split_from_line_id ) ;
3411:
3412: -- Define a cursor which gets receiving transactions records for given order line id

Line 3431: and wdt.source_line_id in ( Select line_id from oe_order_lines_all

3427: From wsh_delivery_details wdt,
3428: Wsh_Serial_Numbers wsn
3429: Where wdt.Released_Status in ( 'C', 'I')
3430: and wdt.source_header_id = p_order_header_Id
3431: and wdt.source_line_id in ( Select line_id from oe_order_lines_all
3432: start with line_id = p_Order_Line_Id
3433: connect by prior line_id = split_from_line_id )
3434: and wdt.delivery_detail_id = wsn.delivery_detail_id(+);
3435: