DBA Data[Home] [Help]

APPS.GMIVDX dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 1911: update mtl_onhand_quantities_detail

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
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)) )