APPS.INV_LABEL_PVT2 dependencies on MTL_MATERIAL_STATUSES_VL

Line 107: l_lot_status mtl_material_statuses_vl.status_code%TYPE; -- Bug 4355080

103:
104: l_maturity_date mtl_lot_numbers.maturity_date%TYPE;
105: l_retest_date mtl_lot_numbers.retest_date%TYPE;
106: l_origination_date mtl_lot_numbers.origination_date%TYPE;
107: l_lot_status mtl_material_statuses_vl.status_code%TYPE; -- Bug 4355080
108: -- invconv enf
109:
110:
111: -- For Receipt, Inspection, Putaway, Delivery,

Line 883: , mtl_material_statuses_vl mmsvl1

879: , mln.width_uom lot_width_uom
880: , mln.curl_wrinkle_fold lot_curl
881: , mln.vendor_name lot_vendor
882: FROM mtl_lot_numbers mln
883: , mtl_material_statuses_vl mmsvl1
884: , mtl_parameters mp
885: , (SELECT msik.concatenated_segments item
886: , msik.inventory_item_id inventory_item_id
887: , msik.organization_id organization_id

Line 989: , mtl_material_statuses_vl mmsvl2

985: , -- Added as part of change for patchset "I".
986: wilk.concatenated_segments LOCATOR
987: --milk.concatenated_segments LOCATOR -- Modified for bug # 5015415
988: FROM mtl_system_items_vl msik
989: , mtl_material_statuses_vl mmsvl2
990: , po_hazard_classes poh
991: , mtl_serial_numbers msn
992: , cst_cost_groups ccg
993: , wip_entities wipent

Line 1045: mtl_material_statuses_vl sts

1041: origination_date,
1042: sts.status_code
1043: FROM
1044: MTL_LOT_NUMBERS l,
1045: mtl_material_statuses_vl sts
1046: WHERE LOT_NUMBER = l_lot_number AND
1047: INVENTORY_ITEM_ID = l_inventory_item_id AND
1048: ORGANIZATION_ID = l_organization_id
1049: AND sts.status_id(+) = l.status_id; -- Bug 4355080

Line 1068: mtl_material_statuses_vl sts

1064: lot_expiration_date,
1065: origination_date,
1066: sts.status_code
1067: FROM mtl_transaction_lots_temp t,
1068: mtl_material_statuses_vl sts
1069: WHERE transaction_temp_id = p_input_param.transaction_temp_id AND
1070: lot_number = l_lot_number
1071: AND sts.status_id(+) = t.status_id; -- Bug 4355080
1072: