DBA Data[Home] [Help]

APPS.FLM_LOGICAL_KANBAN dependencies on MTL_SYSTEM_ITEMS

Line 37: from mtl_system_items_kfv a , mtl_parameters b,

33:
34: Begin
35: Select concatenated_segments,organization_code,subinventory_name,locator_id,pull.organization_id
36: into x_item_name,x_org_code,x_subinventory,l_locator_id,l_organization_id
37: from mtl_system_items_kfv a , mtl_parameters b,
38: mtl_kanban_pull_sequences pull
39: where a.inventory_item_id = pull.inventory_item_id
40: and a.organization_id = Pull.organization_id
41: and b.organization_id = Pull.organization_id

Line 65: mtl_system_items msi

61: msi.LOT_CONTROL_CODE,
62: msi.SERIAL_NUMBER_CONTROL_CODE,
63: msi.REVISION_QTY_CONTROL_CODE
64: FROM MTL_KANBAN_PULL_SEQUENCES mkps,
65: mtl_system_items msi
66: WHERE mkps.replenishment_type = 1 --'Logical'
67: AND mkps.organization_id = p_organizationID
68: AND mkps.inventory_item_id = msi.inventory_item_id
69: AND mkps.organization_id = msi.organization_id