[Home] [Help]
149: wjsi_row.interface_id,
150: wjsi_row.build_sequence);
151: end if;
152: --select records from other tables that need to be accessed multiple times throughout the validation
153: --procedures, e.g. mtl_system_items row for the primary item
154: setup;
155:
156: --only perform a subset of the validations, mostly those odd cases in which the validation procedures
157: --modify or insert date
384:
385: --job must have an assembly, and the assembly must be serial controlled (predefined).
386: select 1
387: into g_dummy
388: from wip_discrete_jobs wdj, mtl_system_items msi
389: where wdj.primary_item_id = msi.inventory_item_id
390: and wdj.organization_id = msi.organization_id
391: and wdj.wip_entity_id = l_wipID
392: and msi.serial_number_control_code = wip_constants.full_sn;
457: x_item_row.restrict_locators_code,
458: x_item_row.location_control_code,
459: x_item_row.fixed_lead_time,
460: x_item_row.variable_lead_time
461: from mtl_system_items
462: where inventory_item_id = p_item_id
463: and organization_id = p_org_id;
464: end populate_item;
465:
1088: X_Eng_Items_Flag := to_number(FND_PROFILE.value('WIP_SEE_ENG_ITEMS'));
1089: begin
1090: select 1
1091: into l_dummy
1092: from MTL_SYSTEM_ITEMS msi
1093: where msi.inventory_item_id = wjsi_row.primary_item_id
1094: and msi.organization_id= wjsi_row.organization_id
1095: and msi.replenish_to_order_flag = 'Y'
1096: and msi.bom_item_type = 4
1226: if(wjsi_row.load_type = wip_constants.create_ns_job and
1227: wjsi_row.bom_reference_id is not null) then
1228: select 1
1229: into g_dummy
1230: from mtl_system_items
1231: where inventory_item_id = wjsi_row.bom_reference_id
1232: and organization_id = wjsi_row.organization_id
1233: and build_in_wip_flag = 'Y'
1234: and pick_components_flag = 'N'
1699: wjsi_row.rebuild_item_id is not null) then
1700: l_inv_item_id := wjsi_row.rebuild_item_id;
1701: select inventory_asset_flag, restrict_subinventories_code
1702: into l_inv_asset_flag, l_restrict_subinv_code
1703: from mtl_system_items
1704: where inventory_item_id = l_inv_item_id
1705: and organization_id = wjsi_row.organization_id;
1706: else
1707: l_inv_item_id := wjsi_row.primary_item_id;
1787: end if;
1788: if(l_item_id is not null) then
1789: select restrict_locators_code, location_control_code
1790: into l_restrict_locs, l_item_loc_control
1791: from mtl_system_items
1792: where inventory_item_id = l_item_id
1793: and organization_id = wjsi_row.organization_id;
1794: else
1795: return; --no need for locator validation
2346: if(wjsi_row.load_type = wip_constants.create_eam_job) then
2347: if(wjsi_row.asset_group_id is not null) then
2348: select 1
2349: into g_dummy
2350: from mtl_system_items
2351: where inventory_item_id = wjsi_row.asset_group_id
2352: and organization_id = wjsi_row.organization_id
2353: and eam_item_type = 1; -- asset group
2354: elsif(wjsi_row.rebuild_item_id is null) then
2393: if(wjsi_row.load_type = wip_constants.create_eam_job and
2394: wjsi_row.rebuild_item_id is not null) then
2395: select 1
2396: into g_dummy
2397: from mtl_system_items
2398: where inventory_item_id = wjsi_row.rebuild_item_id
2399: and organization_id = wjsi_row.organization_id
2400: and eam_item_type = 3;
2401: end if;
2607: elsif(wjsi_row.rebuild_item_id is not null) then
2608:
2609: select serial_number_control_code
2610: into l_serial_number_control_code
2611: from mtl_system_items
2612: where organization_id = wjsi_row.organization_id
2613: and inventory_item_id = wjsi_row.rebuild_item_id;
2614:
2615: if(l_serial_number_control_code in (2, 5, 6) and