DBA Data[Home] [Help]

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 1028: mtl_item_categories mic,

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

Line 1145: mtl_item_categories mic,

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

Line 1397: mtl_item_categories mic,

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