DBA Data[Home] [Help]

APPS.GMIVDX dependencies on MTL_MATERIAL_STATUSES

Line 1912: set status_id = (select status_id from mtl_material_statuses

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
1911: update mtl_onhand_quantities_detail
1912: set status_id = (select status_id from mtl_material_statuses
1913: where status_code = (select opm_lot_status from gmi_discrete_transfer_lots
1914: where transfer_id = (select transaction_source_id from mtl_material_transactions
1915: where transaction_set_id = p_hdr_rec.transaction_header_id)) )
1916: where create_transaction_id = (select transaction_id from mtl_material_transactions