DBA Data[Home] [Help]

APPS.GMIVDX dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 1904: update mtl_onhand_quantities_detail

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
1904: update mtl_onhand_quantities_detail
1905: set status_id = (select status_id from mtl_material_statuses
1906: where status_code = (select opm_lot_status from gmi_discrete_transfer_lots
1907: where transfer_id = (select transaction_source_id from mtl_material_transactions
1908: where transaction_set_id = p_hdr_rec.transaction_header_id)) )