DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1158: from mtl_system_items_kfv msik

1154: and wjsi.load_type in (wip_constants.create_job,
1155: wip_constants.create_ns_job,
1156: wip_constants.create_sched)
1157: and not exists (select 1
1158: from mtl_system_items_kfv msik
1159: where msik.organization_id = wjsi.organization_id
1160: and msik.concatenated_segments = wjsi.primary_item_segments)
1161: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1162:

Line 1171: from mtl_system_items_kfv msik

1167: end if;
1168:
1169: update wip_job_schedule_interface wjsi
1170: set wjsi.primary_item_id = (select msik.inventory_item_id
1171: from mtl_system_items_kfv msik
1172: where msik.organization_id = wjsi.organization_id
1173: and msik.concatenated_segments = wjsi.primary_item_segments),
1174: wjsi.last_update_date = sysdate
1175: where wjsi.group_id = p_groupID

Line 1194: from mtl_system_items msi

1190: and wjsi.primary_item_id is not null
1191: and ( wjsi.load_type in (wip_constants.create_job, wip_constants.create_sched)
1192: or (wjsi.load_type = wip_constants.create_ns_job and wjsi.primary_item_id is not null) )
1193: and not exists (select 1
1194: from mtl_system_items msi
1195: where msi.organization_id = wjsi.organization_id
1196: and msi.inventory_item_id = wjsi.primary_item_id)
1197: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1198:

Line 1218: from mtl_system_items msi

1214: wjsi.load_type in (wip_constants.create_job,
1215: wip_constants.create_ns_job,
1216: wip_constants.create_sched) and
1217: ( 'Y' <> (select msi.build_in_wip_flag
1218: from mtl_system_items msi
1219: where msi.organization_id = wjsi.organization_id
1220: and msi.inventory_item_id = wjsi.primary_item_id) or
1221: 'N' <> (select msi.pick_components_flag
1222: from mtl_system_items msi

Line 1222: from mtl_system_items msi

1218: from mtl_system_items msi
1219: where msi.organization_id = wjsi.organization_id
1220: and msi.inventory_item_id = wjsi.primary_item_id) or
1221: 'N' <> (select msi.pick_components_flag
1222: from mtl_system_items msi
1223: where msi.organization_id = wjsi.organization_id
1224: and msi.inventory_item_id = wjsi.primary_item_id) or
1225: (l_see_eng_items_flag = wip_constants.no and
1226: 'Y' = (select msi.eng_item_flag

Line 1227: from mtl_system_items msi

1223: where msi.organization_id = wjsi.organization_id
1224: and msi.inventory_item_id = wjsi.primary_item_id) or
1225: (l_see_eng_items_flag = wip_constants.no and
1226: 'Y' = (select msi.eng_item_flag
1227: from mtl_system_items msi
1228: where msi.organization_id = wjsi.organization_id
1229: and msi.inventory_item_id = wjsi.primary_item_id)))))
1230: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1231:

Line 1270: from mtl_system_items msi

1266: wip_constants.create_sched,
1267: wip_constants.create_ns_job)
1268: and wjsi.primary_item_id is not null
1269: and 'Y' = (select msi.replenish_to_order_flag
1270: from mtl_system_items msi
1271: where msi.organization_id = wjsi.organization_id
1272: and msi.inventory_item_id = wjsi.primary_item_id)
1273: and 4 = (select msi.bom_item_type
1274: from mtl_system_items msi

Line 1274: from mtl_system_items msi

1270: from mtl_system_items msi
1271: where msi.organization_id = wjsi.organization_id
1272: and msi.inventory_item_id = wjsi.primary_item_id)
1273: and 4 = (select msi.bom_item_type
1274: from mtl_system_items msi
1275: where msi.organization_id = wjsi.organization_id
1276: and msi.inventory_item_id = wjsi.primary_item_id)
1277: and not exists (select 1
1278: from bom_bill_of_materials bom

Line 1431: from mtl_system_items_kfv msik

1427: and wdj.organization_id = wjsi.organization_id)))
1428: and wjsi.routing_reference_segments is not null
1429: and wjsi.routing_reference_id is null
1430: and not exists (select 1
1431: from mtl_system_items_kfv msik
1432: where msik.organization_id = wjsi.organization_id
1433: and msik.concatenated_segments = wjsi.routing_reference_segments)
1434: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1435:

Line 1449: from mtl_system_items_kfv msik

1445: from wip_discrete_jobs wdj
1446: where wdj.wip_entity_id = wjsi.wip_entity_id
1447: and wdj.organization_id = wjsi.organization_id),
1448: (select inventory_item_id
1449: from mtl_system_items_kfv msik
1450: where msik.organization_id = wjsi.organization_id
1451: and msik.concatenated_segments = wjsi.routing_reference_segments)),
1452: wjsi.last_update_date = sysdate
1453: where wjsi.group_id = p_groupID

Line 1481: from mtl_system_items_kfv msik

1477: where wdj.wip_entity_id = wjsi.wip_entity_id
1478: and wdj.organization_id = wjsi.organization_id)))
1479: and wjsi.routing_reference_id is not null
1480: and not exists (select 1
1481: from mtl_system_items_kfv msik
1482: where msik.organization_id = wjsi.organization_id
1483: and msik.inventory_item_id = wjsi.routing_reference_id)
1484: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1485:

Line 1506: from mtl_system_items msi

1502: where wdj.wip_entity_id = wjsi.wip_entity_id
1503: and wdj.organization_id = wjsi.organization_id)))
1504: and wjsi.routing_reference_id is not null
1505: and ('Y' <> (select msi.build_in_wip_flag
1506: from mtl_system_items msi
1507: where msi.organization_id = wjsi.organization_id
1508: and msi.inventory_item_id = wjsi.routing_reference_id) or
1509: 'N' <> (select msi.pick_components_flag
1510: from mtl_system_items msi

Line 1510: from mtl_system_items msi

1506: from mtl_system_items msi
1507: where msi.organization_id = wjsi.organization_id
1508: and msi.inventory_item_id = wjsi.routing_reference_id) or
1509: 'N' <> (select msi.pick_components_flag
1510: from mtl_system_items msi
1511: where msi.organization_id = wjsi.organization_id
1512: and msi.inventory_item_id = wjsi.routing_reference_id) or
1513: (l_see_eng_items_flag = wip_constants.no and
1514: 'Y' = (select msi.eng_item_flag

Line 1515: from mtl_system_items msi

1511: where msi.organization_id = wjsi.organization_id
1512: and msi.inventory_item_id = wjsi.routing_reference_id) or
1513: (l_see_eng_items_flag = wip_constants.no and
1514: 'Y' = (select msi.eng_item_flag
1515: from mtl_system_items msi
1516: where msi.organization_id = wjsi.organization_id
1517: and msi.inventory_item_id = wjsi.routing_reference_id)))
1518: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1519:

Line 1773: from mtl_system_items_kfv msik

1769: and wdj.organization_id = wjsi.organization_id)))
1770: and wjsi.bom_reference_segments is not null
1771: and wjsi.bom_reference_id is null
1772: and not exists (select 1
1773: from mtl_system_items_kfv msik
1774: where msik.organization_id = wjsi.organization_id
1775: and msik.concatenated_segments = wjsi.bom_reference_segments)
1776: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1777:

Line 1791: from mtl_system_items_kfv msik

1787: from wip_discrete_jobs wdj
1788: where wdj.wip_entity_id = wjsi.wip_entity_id
1789: and wdj.organization_id = wjsi.organization_id),
1790: (select inventory_item_id
1791: from mtl_system_items_kfv msik
1792: where msik.organization_id = wjsi.organization_id
1793: and msik.concatenated_segments = wjsi.bom_reference_segments)),
1794: wjsi.last_update_date = sysdate
1795: where wjsi.group_id = p_groupID

Line 1823: from mtl_system_items_kfv msik

1819: where wdj.wip_entity_id = wjsi.wip_entity_id
1820: and wdj.organization_id = wjsi.organization_id)))
1821: and wjsi.bom_reference_id is not null
1822: and not exists (select 1
1823: from mtl_system_items_kfv msik
1824: where msik.organization_id = wjsi.organization_id
1825: and msik.inventory_item_id = wjsi.bom_reference_id)
1826: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1827:

Line 1848: from mtl_system_items msi

1844: where wdj.wip_entity_id = wjsi.wip_entity_id
1845: and wdj.organization_id = wjsi.organization_id)))
1846: and wjsi.bom_reference_id is not null
1847: and ('Y' <> (select msi.build_in_wip_flag
1848: from mtl_system_items msi
1849: where msi.organization_id = wjsi.organization_id
1850: and msi.inventory_item_id = wjsi.bom_reference_id) or
1851: 'N' <> (select msi.pick_components_flag
1852: from mtl_system_items msi

Line 1852: from mtl_system_items msi

1848: from mtl_system_items msi
1849: where msi.organization_id = wjsi.organization_id
1850: and msi.inventory_item_id = wjsi.bom_reference_id) or
1851: 'N' <> (select msi.pick_components_flag
1852: from mtl_system_items msi
1853: where msi.organization_id = wjsi.organization_id
1854: and msi.inventory_item_id = wjsi.bom_reference_id) or
1855: (l_see_eng_items_flag = wip_constants.no and
1856: 'Y' = (select msi.eng_item_flag

Line 1857: from mtl_system_items msi

1853: where msi.organization_id = wjsi.organization_id
1854: and msi.inventory_item_id = wjsi.bom_reference_id) or
1855: (l_see_eng_items_flag = wip_constants.no and
1856: 'Y' = (select msi.eng_item_flag
1857: from mtl_system_items msi
1858: where msi.organization_id = wjsi.organization_id
1859: and msi.inventory_item_id = wjsi.bom_reference_id)))
1860: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1861:

Line 3311: from mtl_system_items

3307: primary_item_row.restrict_locators_code,
3308: primary_item_row.location_control_code,
3309: primary_item_row.fixed_lead_time,
3310: primary_item_row.variable_lead_time
3311: from mtl_system_items
3312: where inventory_item_id = l_primaryItemID
3313: and organization_id = wjsi_row.organization_id;
3314: end if;
3315: end setup;

Line 4396: from mtl_system_items

4392: update wip_discrete_jobs
4393: set serialization_start_op = p_rtgVal
4394: where wip_entity_id = l_wipID
4395: and exists (select 1
4396: from mtl_system_items
4397: where inventory_item_id = l_primaryItem
4398: and organization_id = l_orgID
4399: and serial_number_control_code = wip_constants.full_sn);
4400:

Line 4408: from mtl_system_items

4404: from wip_operations
4405: where wip_entity_id = l_wipID)
4406: where wip_entity_id = l_wipID
4407: and exists (select 1
4408: from mtl_system_items
4409: where inventory_item_id = l_primaryItem
4410: and organization_id = l_orgID
4411: and serial_number_control_code = wip_constants.full_sn);
4412: end if;

Line 4468: mtl_system_items msi

4464: --job must have an assembly, and the assembly must be serial controlled (predefined).
4465: select 1
4466: into l_dummy
4467: from wip_discrete_jobs wdj,
4468: mtl_system_items msi
4469: where wdj.primary_item_id = msi.inventory_item_id
4470: and wdj.organization_id = msi.organization_id
4471: and wdj.wip_entity_id = l_wipEntityID
4472: and msi.serial_number_control_code = wip_constants.full_sn;