DBA Data[Home] [Help]

APPS.GMIVDX dependencies on MTL_SYSTEM_ITEMS

Line 1899: from mtl_system_items_b

1895:
1896: --rlnagara 2 Material Status Migration ME start - Added the below code to update the status in MOQD
1897: select lot_control_code, lot_status_enabled
1898: into l_lot_ctl, l_lot_sts
1899: from mtl_system_items_b
1900: where inventory_item_id = (select inventory_item_id from mtl_material_transactions where transaction_set_id = p_hdr_rec.transaction_header_id)
1901: and organization_id = (select organization_id from mtl_material_transactions where transaction_set_id = p_hdr_rec.transaction_header_id);
1902:
1903: IF l_lot_ctl = 2 and l_lot_sts = 'Y' THEN