[Home] [Help]
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,
885: , mln.width_uom lot_width_uom
886: , mln.curl_wrinkle_fold lot_curl
887: , mln.vendor_name lot_vendor
888: FROM mtl_lot_numbers mln
889: , mtl_material_statuses_vl mmsvl1
890: , mtl_parameters mp
891: , (SELECT msik.concatenated_segments item
892: , WMS_DEPLOY.GET_CLIENT_ITEM(l_organization_id, msik.inventory_item_id) client_item -- Added for LSP Project, bug 9087971
893: , msik.inventory_item_id inventory_item_id
992: , -- Added as part of change for patchset "I".
993: wilk.concatenated_segments LOCATOR
994: --milk.concatenated_segments LOCATOR -- Modified for bug # 5015415
995: FROM mtl_system_items_vl msik
996: , mtl_material_statuses_vl mmsvl2
997: , po_hazard_classes poh
998: , mtl_serial_numbers msn
999: , cst_cost_groups ccg
1000: , wip_entities wipent
1048: origination_date,
1049: sts.status_code
1050: FROM
1051: MTL_LOT_NUMBERS l,
1052: mtl_material_statuses_vl sts
1053: WHERE LOT_NUMBER = l_lot_number AND
1054: INVENTORY_ITEM_ID = l_inventory_item_id AND
1055: ORGANIZATION_ID = l_organization_id
1056: AND sts.status_id(+) = l.status_id; -- Bug 4355080
1071: lot_expiration_date,
1072: origination_date,
1073: sts.status_code
1074: FROM mtl_transaction_lots_temp t,
1075: mtl_material_statuses_vl sts
1076: WHERE transaction_temp_id = p_input_param.transaction_temp_id AND
1077: lot_number = l_lot_number
1078: AND sts.status_id(+) = t.status_id; -- Bug 4355080
1079: