DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG3 dependencies on MTL_SYSTEM_ITEMS

Line 2614: FROM mtl_system_items MSI, cs_estimate_details ced

2610: --Cursor to get primary_uom_code for the estimate line item.
2611: CURSOR cur_getUOMForEstLineItem(p_estimate_detail_id NUMBER)
2612: IS
2613: SELECT primary_uom_code
2614: FROM mtl_system_items MSI, cs_estimate_details ced
2615: WHERE CED.estimate_detail_id = p_estimate_detail_id
2616: AND MSI.inventory_item_id = CED.inventory_item_id
2617: AND MSI.organization_id = cs_std.get_item_valdn_orgzn_id;
2618:

Line 3383: mtl_system_items_b msi

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
3387: and cr.repair_type_id = crt.repair_type_id