DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on MTL_SYSTEM_ITEMS

Line 293: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl

289: BEGIN
290: BEGIN
291: SELECT msik.lot_control_code
292: INTO l_lot_control_code
293: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl
294: WHERE msik.inventory_item_id = p_item_id
295: AND msik.inventory_item_id = rsl.item_id --Bug 4235750
296: AND rsl.shipment_header_id = p_shipment_header_id
297: AND rsl.to_organization_id = p_organization_id

Line 628: FROM org_organization_definitions org, mtl_system_items msi

624: OPEN x_to_org_lov FOR
625: SELECT DISTINCT org.organization_id
626: , org.organization_code
627: , org.organization_name
628: FROM org_organization_definitions org, mtl_system_items msi
629: WHERE org.organization_id <> p_from_organization_id
630: AND org.organization_id = msi.organization_id
631: AND msi.inventory_item_id IN (SELECT inventory_item_id
632: FROM mtl_system_items

Line 632: FROM mtl_system_items

628: FROM org_organization_definitions org, mtl_system_items msi
629: WHERE org.organization_id <> p_from_organization_id
630: AND org.organization_id = msi.organization_id
631: AND msi.inventory_item_id IN (SELECT inventory_item_id
632: FROM mtl_system_items
633: WHERE organization_id = p_from_organization_id)
634: AND org.organization_code LIKE (p_to_organization_code);
635: END get_to_org_lov;
636:

Line 937: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

933: , msik.description
934: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
935: , mms.status_code status_code
936: , mms.status_id
937: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
938: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
939: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
940: AND mln.organization_id = p_organization_id
941: AND mln.organization_id = msik.organization_id

Line 956: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

952: , msik.description
953: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
954: , NULL status_code
955: , msik.default_lot_status_id -- Bug#2267947
956: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
957: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
958: AND mln.organization_id = p_organization_id
959: AND mln.organization_id = msik.organization_id
960: AND mln.inventory_item_id = msik.inventory_item_id

Line 977: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

973: , msik.description
974: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
975: , mms.status_code
976: , mms.status_id
977: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
978: WHERE moq.organization_id = p_organization_id
979: AND moq.lot_number IS NOT NULL
980: AND moq.organization_id = mil.organization_id
981: AND moq.organization_id = mln.organization_id

Line 1006: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

1002: , msik.description
1003: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1004: , NULL status_code
1005: , msik.default_lot_status_id -- Bug#2267947
1006: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1007: WHERE moq.organization_id = p_organization_id
1008: AND moq.lot_number IS NOT NULL
1009: AND moq.organization_id = mil.organization_id
1010: AND moq.organization_id = mln.organization_id

Line 1036: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1032: , msik.description
1033: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1034: , mms.status_code
1035: , mms.status_id
1036: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1037: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1038: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1039: AND mln.organization_id = p_organization_id
1040: AND mln.organization_id = msik.organization_id

Line 1055: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1051: , msik.description
1052: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1053: , NULL status_code
1054: , msik.default_lot_status_id -- Bug#2267947
1055: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1056: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1057: AND mln.organization_id = p_organization_id
1058: AND mln.organization_id = msik.organization_id
1059: AND mln.inventory_item_id = msik.inventory_item_id

Line 1078: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1074: , msik.description
1075: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1076: , mms.status_code
1077: , mms.status_id
1078: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1079: WHERE mms.status_id = msik.default_lot_status_id
1080: AND msik.default_lot_status_id IS NOT NULL
1081: AND mln.organization_id = p_organization_id
1082: AND mln.organization_id = msik.organization_id

Line 1098: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1094: , msik.description
1095: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1096: , NULL status_code
1097: , msik.default_lot_status_id -- Bug#2267947
1098: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1099: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1100: AND mln.organization_id = p_organization_id
1101: AND mln.organization_id = msik.organization_id
1102: AND mln.inventory_item_id = msik.inventory_item_id

Line 1117: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1113: , msik.description
1114: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1115: , mms.status_code
1116: , mms.status_id
1117: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1118: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1119: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1120: AND mln.organization_id = p_organization_id
1121: AND mln.organization_id = msik.organization_id

Line 1136: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1132: , msik.description
1133: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1134: , NULL status_code
1135: , msik.default_lot_status_id -- Bug#2267947
1136: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1137: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1138: AND mln.organization_id = p_organization_id
1139: AND mln.organization_id = msik.organization_id
1140: AND mln.inventory_item_id = msik.inventory_item_id

Line 1212: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1208: , msik.description
1209: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1210: , mms.status_code status_code
1211: , mms.status_id
1212: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1213: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1214: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1215: AND mln.organization_id = p_organization_id
1216: AND mln.organization_id = msik.organization_id

Line 1230: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1226: , msik.description
1227: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1228: , NULL status_code
1229: , msik.default_lot_status_id -- Bug#2267947
1230: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1231: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1232: AND mln.organization_id = p_organization_id
1233: AND mln.organization_id = msik.organization_id
1234: AND mln.inventory_item_id = msik.inventory_item_id

Line 1251: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

1247: , msik.description
1248: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1249: , mms.status_code
1250: , mms.status_id
1251: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1252: WHERE moq.organization_id = p_organization_id
1253: AND moq.lot_number IS NOT NULL
1254: AND moq.organization_id = mil.organization_id
1255: AND moq.organization_id = mln.organization_id

Line 1281: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

1277: , msik.description
1278: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1279: , NULL status_code
1280: , msik.default_lot_status_id -- Bug#2267947
1281: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1282: WHERE moq.organization_id = p_organization_id
1283: AND moq.lot_number IS NOT NULL
1284: AND moq.organization_id = mil.organization_id
1285: AND moq.organization_id = mln.organization_id

Line 1312: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1308: , msik.description
1309: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1310: , mms.status_code
1311: , mms.status_id
1312: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1313: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1314: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1315: AND mln.organization_id = p_organization_id
1316: AND mln.organization_id = msik.organization_id

Line 1331: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1327: , msik.description
1328: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1329: , (select status_code from mtl_material_statuses_vl where status_id = mln.status_id) status_code
1330: , mln.status_id -- Bug#2347381
1331: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1332: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1333: AND mln.organization_id = p_organization_id
1334: AND mln.organization_id = msik.organization_id
1335: AND mln.inventory_item_id = msik.inventory_item_id

Line 1354: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1350: , msik.description
1351: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1352: , mms.status_code
1353: , mms.status_id
1354: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1355: WHERE mms.status_id = msik.default_lot_status_id
1356: AND msik.default_lot_status_id IS NOT NULL
1357: AND mln.organization_id = p_organization_id
1358: AND mln.organization_id = msik.organization_id

Line 1373: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1369: , msik.description
1370: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1371: , NULL status_code
1372: , msik.default_lot_status_id -- Bug#2267947
1373: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1374: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1375: AND mln.organization_id = p_organization_id
1376: AND mln.organization_id = msik.organization_id
1377: AND mln.inventory_item_id = msik.inventory_item_id

Line 1392: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms

1388: , msik.description
1389: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1390: , mms.status_code
1391: , mms.status_id
1392: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms
1393: WHERE mms.status_id = msik.default_lot_status_id -- Bug#2267947
1394: AND msik.default_lot_status_id IS NOT NULL -- Bug#2267947
1395: AND mln.organization_id = p_organization_id
1396: AND mln.organization_id = msik.organization_id

Line 1410: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik

1406: , msik.description
1407: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1408: , NULL status_code
1409: , msik.default_lot_status_id -- Bug#2267947
1410: FROM mtl_lot_numbers mln, mtl_system_items_kfv msik
1411: WHERE msik.default_lot_status_id IS NULL -- Bug#2267947
1412: AND mln.organization_id = p_organization_id
1413: AND mln.organization_id = msik.organization_id
1414: AND mln.inventory_item_id = msik.inventory_item_id

Line 1573: FROM mtl_system_items

1569:
1570: -- Get the serial number control code for the item
1571: SELECT NVL(serial_number_control_code, 1)
1572: INTO l_serial_number_control_code
1573: FROM mtl_system_items
1574: WHERE inventory_item_id = p_inventory_item_id
1575: AND organization_id = p_organization_id;
1576:
1577: IF (p_unscheduled_entry = 1) THEN -- Unscheduled entries are allowed

Line 2244: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl

2240: SELECT msik.lot_control_code
2241: , rsl.from_organization_id
2242: INTO x_lot_control_code
2243: , x_from_org_id
2244: FROM mtl_system_items_kfv msik, rcv_shipment_lines rsl
2245: WHERE msik.inventory_item_id = p_item_id
2246: AND rsl.shipment_header_id = p_shipment_header_id
2247: AND rsl.to_organization_id = p_organization_id
2248: AND rsl.from_organization_id = msik.organization_id