APPS.MRP_KANBAN_SNAPSHOT_PK dependencies on MTL_ITEM_CATEGORIES

Line 642: l_additional_tables := ' mtl_item_categories mic, ';

638:
639: flm_util.init_bind;
640:
641: -- include category set in the sql stmt
642: l_additional_tables := ' mtl_item_categories mic, ';
643: l_additional_where :=
644: ' AND mic.category_set_id (+) = :b_category_set_id' ||
645: ' AND mic.inventory_item_id (+) = msi.inventory_item_id' ||
646: ' AND mic.organization_id (+) = msi.organization_id ';

Line 1029: mtl_item_categories mic,

1025: sysdate
1026: FROM
1027: mtl_kanban_pull_sequences ps,
1028: bom_bill_of_materials bbom,
1029: mtl_item_categories mic,
1030: bom_inventory_components mrp_bic,
1031: mrp_low_level_codes mllc
1032: WHERE mllc.plan_id =
1033: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

Line 1146: mtl_item_categories mic,

1142: sysdate
1143: FROM
1144: mtl_kanban_pull_sequences ps,
1145: bom_bill_of_materials bbom,
1146: mtl_item_categories mic,
1147: bom_inventory_components mrp_bic,
1148: mrp_low_level_codes mllc
1149: WHERE mllc.plan_id =
1150: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

Line 1398: mtl_item_categories mic,

1394: sysdate,
1395: fnd_global.user_id,
1396: sysdate
1397: FROM
1398: mtl_item_categories mic,
1399: mtl_kanban_pull_sequences kbn_items,
1400: mrp_low_level_codes mllc1
1401: WHERE
1402: mllc1.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id AND