APPS.FLM_KANBAN dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 80: mtl_kanban_pull_sequences

76: SELECT
77: source_subinventory,
78: source_locator_id
79: FROM
80: mtl_kanban_pull_sequences
81: WHERE
82: organization_id = i_org_id AND
83: kanban_plan_id = -1 AND
84: source_type = 3 AND

Line 726: *** trace down in mtl_kanban_pull_sequences, if the last POS has the same

722: /***
723: *** Retrieve POU locators for items according to i_locator_options:
724: *** 1. BOM - locators are from bom_inventory_components;
725: *** 2. Pull Sequence - Starting from BOM (item_id, subinventory, locator_id),
726: *** trace down in mtl_kanban_pull_sequences, if the last POS has the same
727: *** subinventory as template (i_template_sub), retrieve its locator;
728: *** 3. Default - use specified default locator (i_pou_default_locator_id).
729: ***
730: *** Note that for all three options, items retrieved must not be phantom,

Line 1066: FROM mtl_kanban_pull_sequences

1062:
1063: -- find out the kanban-plan-id, subinventory, locator-id, item, and organization id
1064: SELECT kanban_plan_id, subinventory_name, locator_id, inventory_item_id, organization_id
1065: INTO l_kp_id, l_des_sub, l_des_locid, l_des_compid, l_org_id
1066: FROM mtl_kanban_pull_sequences
1067: WHERE pull_sequence_id = i_pull_sequence_id;
1068:
1069: IF NOT l_des_locid IS NULL
1070: THEN

Line 1465: FROM mtl_kanban_pull_sequences

1461:
1462: -- find out the kanban-plan-id, subinventory, locator-id, and item
1463: SELECT kanban_plan_id, subinventory_name, locator_id, inventory_item_id, organization_id
1464: INTO l_kp_id, l_des_sub, l_des_locid, l_des_compid, l_org_id
1465: FROM mtl_kanban_pull_sequences
1466: WHERE pull_sequence_id = i_pull_sequence_id;
1467:
1468: -- DBMS_OUTPUT.PUT_LINE(l_kp_id || l_des_sub || l_des_locid || l_des_compid);
1469: