DBA Data[Home] [Help]

APPS.GMIVDX dependencies on MTL_SYSTEM_ITEMS

Line 1906: from mtl_system_items_b

1902:
1903: --rlnagara 2 Material Status Migration ME start - Added the below code to update the status in MOQD
1904: select lot_control_code, lot_status_enabled
1905: into l_lot_ctl, l_lot_sts
1906: from mtl_system_items_b
1907: where inventory_item_id = (select inventory_item_id from mtl_material_transactions where transaction_set_id = p_hdr_rec.transaction_header_id)
1908: and organization_id = (select organization_id from mtl_material_transactions where transaction_set_id = p_hdr_rec.transaction_header_id);
1909:
1910: IF l_lot_ctl = 2 and l_lot_sts = 'Y' THEN