APPS.INV_LABEL_PVT5 dependencies on MTL_MATERIAL_STATUSES

Line 913: , mtl_material_statuses_vl mmsv

909: , mtl_system_items_kfv msik
910: , mtl_transaction_lots_temp mtlt
911: , mtl_material_transactions_temp mmtt
912: , po_hazard_classes poh
913: , mtl_material_statuses_vl mmsv
914: WHERE msik.inventory_item_id = p_item_id
915: AND msik.organization_id = p_org_id
916: AND mp.organization_id = msik.organization_id
917: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id

Line 1024: , mtl_material_statuses_vl mmsv

1020: FROM mtl_parameters mp
1021: ,mtl_system_items_kfv msik
1022: , mtl_lot_numbers mln
1023: , po_hazard_classes poh
1024: , mtl_material_statuses_vl mmsv
1025: WHERE msik.inventory_item_id = p_item_id
1026: AND msik.organization_id = p_org_id
1027: AND mp.organization_id = msik.organization_id
1028: AND mln.organization_id (+) = msik.organization_id

Line 1457: l_material_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE := NULL; -- Bug 13624825

1453:
1454: --Bug 4891916. Added the local variable to store the cycle count name
1455: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;
1456: --lpn status project start
1457: l_material_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE := NULL; -- Bug 13624825
1458: l_onhand_status_enabled NUMBER := 0;
1459: --lpn status project end
1460:
1461: --START Conf Label ER