[Home] [Help]
996: -- NULL) -- CZH.BUG2398718
997: -- This is for other locator types like Dynamic Entry (3) and
998: -- Item level control (4), which are not supported by OSFM.
999: FROM bom_operational_routings bor,
1000: mtl_secondary_inventories msi -- CZH.BUG2398718
1001: WHERE bor.common_routing_sequence_id = rj.common_routing_sequence_id
1002: AND bor.organization_id = rj.organization_id
1003: --VJ: Start Changes for NSLBJ--
1004: AND bor.assembly_item_id = decode(rj.job_type,
1055: -- This is for other locator types like Dynamic Entry (3) and
1056: -- Item level control (4), which are not supported by OSFM.
1057: FROM wip_discrete_jobs wdj,
1058: wsm_starting_jobs_interface sj,
1059: mtl_secondary_inventories msi -- CZH.BUG2398718
1060: WHERE wdj.wip_entity_id = sj.wip_entity_id
1061: AND wdj.organization_id = sj.organization_id --VJ: Added for NSLBJ--
1062: AND sj.header_id = rj.header_id --VJ: Added for NSLBJ--
1063: AND sj.internal_group_id = WSMPLOAD.G_GROUP_ID
1089: END IF;
1090: -- end 2099827
1091:
1092: -- CZH.BUG2398718, added code to check locator_type,
1093: -- if mtl_secondary_inventories.locator_type is none(=1),
1094: -- set completion_locator_id to NULL, else default it
1095: l_stmt_num := 26;
1096:
1097: /* ST bugfix 3336844 comment out check for locator control with MSI. populate locator_id from BOR regardless
1107: -- This is for other locator types like Dynamic Entry (3) and
1108: -- Item level control (4), which are not supported by OSFM.
1109: FROM wip_discrete_jobs wdj,
1110: wsm_starting_jobs_interface sj,
1111: mtl_secondary_inventories msi -- CZH.BUG2398718
1112: WHERE wdj.wip_entity_id = sj.wip_entity_id
1113: AND sj.header_id = p_header_id -- WLTEnh --rj.header_id
1114: AND sj.internal_group_id = WSMPLOAD.G_GROUP_ID
1115: AND sj.representative_flag = 'Y'
5618: -- NULL) -- CZH.BUG2398718
5619: -- This is for other locator types like Dynamic Entry (3) and
5620: -- Item level control (4), which are not supported by OSFM.
5621: FROM bom_operational_routings bor,
5622: mtl_secondary_inventories msi -- CZH.BUG2398718
5623: WHERE bor.common_routing_sequence_id = rj.common_routing_sequence_id
5624: AND bor.organization_id = rj.organization_id
5625: AND bor.assembly_item_id = decode(rj.job_type,
5626: WIP_CONSTANTS.STANDARD, rj.primary_item_id,
8351: MS.location_control_code item_loc_control
8352: INTO l_sub_loc_control, l_org_loc_control,
8353: l_restrict_locators_code, l_item_loc_control
8354: FROM mtl_system_items MS,
8355: mtl_secondary_inventories MSUB,
8356: mtl_parameters MP
8357: WHERE MP.organization_id = l_organization_id
8358: AND MS.organization_id = l_organization_id
8359: AND MS.inventory_item_id = l_primary_item_id
8412: -- BA: czh.bug2398718
8413: l_stmt_num := 225;
8414: select locator_type
8415: into l_locator_control_type
8416: from mtl_secondary_inventories
8417: where SECONDARY_INVENTORY_NAME = l_comp_sub_inv_r
8418: and organization_id = l_organization_id;
8419: -- EA: czh.bug2398718
8420: