APPS.FLM_LOGICAL_KANBAN dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 38: mtl_kanban_pull_sequences pull

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
42: and pull.pull_sequence_id = p_Pull_sequence_id;

Line 64: FROM MTL_KANBAN_PULL_SEQUENCES mkps,

60: SELECT mkps.*,
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

Line 81: mtl_kanban_pull_sequences mkps

77:
78: CURSOR mul_sup_cur(pull_seq_id NUMBER) IS
79: SELECT mks.*
80: FROM mtl_pull_seq_suppliers mks,
81: mtl_kanban_pull_sequences mkps
82: WHERE mks.pull_sequence_id = pull_seq_id
83: AND mks.pull_sequence_id = mkps.pull_sequence_id
84: AND mkps.organization_id = p_organizationID;
85: