[Home] [Help]
154: wjsi_row.interface_id,
155: wjsi_row.build_sequence);
156: end if;
157: --select records from other tables that need to be accessed multiple times throughout the validation
158: --procedures, e.g. mtl_system_items row for the primary item
159: setup;
160:
161: --only perform a subset of the validations, mostly those odd cases in which the validation procedures
162: --modify or insert date
389:
390: --job must have an assembly, and the assembly must be serial controlled (predefined).
391: select 1
392: into g_dummy
393: from wip_discrete_jobs wdj, mtl_system_items msi
394: where wdj.primary_item_id = msi.inventory_item_id
395: and wdj.organization_id = msi.organization_id
396: and wdj.wip_entity_id = l_wipID
397: and msi.serial_number_control_code = wip_constants.full_sn;
462: x_item_row.restrict_locators_code,
463: x_item_row.location_control_code,
464: x_item_row.fixed_lead_time,
465: x_item_row.variable_lead_time
466: from mtl_system_items
467: where inventory_item_id = p_item_id
468: and organization_id = p_org_id;
469: end populate_item;
470:
1093: X_Eng_Items_Flag := to_number(FND_PROFILE.value('WIP_SEE_ENG_ITEMS'));
1094: begin
1095: select 1
1096: into l_dummy
1097: from MTL_SYSTEM_ITEMS msi
1098: where msi.inventory_item_id = wjsi_row.primary_item_id
1099: and msi.organization_id= wjsi_row.organization_id
1100: and msi.replenish_to_order_flag = 'Y'
1101: and msi.bom_item_type = 4
1231: if(wjsi_row.load_type = wip_constants.create_ns_job and
1232: wjsi_row.bom_reference_id is not null) then
1233: select 1
1234: into g_dummy
1235: from mtl_system_items
1236: where inventory_item_id = wjsi_row.bom_reference_id
1237: and organization_id = wjsi_row.organization_id
1238: and build_in_wip_flag = 'Y'
1239: and pick_components_flag = 'N'
1704: wjsi_row.rebuild_item_id is not null) then
1705: l_inv_item_id := wjsi_row.rebuild_item_id;
1706: select inventory_asset_flag, restrict_subinventories_code
1707: into l_inv_asset_flag, l_restrict_subinv_code
1708: from mtl_system_items
1709: where inventory_item_id = l_inv_item_id
1710: and organization_id = wjsi_row.organization_id;
1711: else
1712: l_inv_item_id := wjsi_row.primary_item_id;
1792: end if;
1793: if(l_item_id is not null) then
1794: select restrict_locators_code, location_control_code
1795: into l_restrict_locs, l_item_loc_control
1796: from mtl_system_items
1797: where inventory_item_id = l_item_id
1798: and organization_id = wjsi_row.organization_id;
1799: else
1800: return; --no need for locator validation
2351: if(wjsi_row.load_type = wip_constants.create_eam_job) then
2352: if(wjsi_row.asset_group_id is not null) then
2353: select 1
2354: into g_dummy
2355: from mtl_system_items
2356: where inventory_item_id = wjsi_row.asset_group_id
2357: and organization_id = wjsi_row.organization_id
2358: and eam_item_type = 1; -- asset group
2359: elsif(wjsi_row.rebuild_item_id is null) then
2398: if(wjsi_row.load_type = wip_constants.create_eam_job and
2399: wjsi_row.rebuild_item_id is not null) then
2400: select 1
2401: into g_dummy
2402: from mtl_system_items
2403: where inventory_item_id = wjsi_row.rebuild_item_id
2404: and organization_id = wjsi_row.organization_id
2405: and eam_item_type = 3;
2406: end if;
2612: elsif(wjsi_row.rebuild_item_id is not null) then
2613:
2614: select serial_number_control_code
2615: into l_serial_number_control_code
2616: from mtl_system_items
2617: where organization_id = wjsi_row.organization_id
2618: and inventory_item_id = wjsi_row.rebuild_item_id;
2619:
2620: if(l_serial_number_control_code in (2, 5, 6) and