[Home] [Help]
150: * the locator present). *
151: * b) The Pull Sequence has Auto_Request flag set to 'Y'. *
152: * c) Pull Sequence is not a Planning Only Pull sequence i.e. *
153: * release_kanban_flag is set to 1. *
154: * d) The item has Supply type as Pull in Bom Inventory Components *
155: * e) The Item has Release Time Fence set to "Kanban Item (Do not *
156: * Release)" in the Organization Items. *
157: * *
158: ************************************************************************/
169: BEGIN
170: SELECT mkps.pull_sequence_id
171: INTO l_pull_sequence_id
172: FROM mtl_kanban_pull_sequences mkps,
173: bom_inventory_components bic,
174: mtl_system_items msi
175: WHERE mkps.inventory_item_id = p_item_id
176: AND mkps.organization_id = p_organization_id
177: AND mkps.auto_request = 'Y'
252: comp.wip_supply_type)) wip_supply_type,
253: MIN(comp.component_quantity) component_quantity,
254: MIN(nvl(comp.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL)) basis_type
255: FROM mtl_system_items sys,
256: bom_inventory_components comp,
257: bom_explosions expl,
258: bom_bill_of_materials bbm
259: WHERE bbm.organization_id = sys.organization_id
260: AND comp.component_item_id = sys.inventory_item_id