eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_KANBAN_SNAPSHOT_PK dependencies on BOM_INVENTORY_COMPONENTS

Line 739: -- information for this item by joining to bom_inventory_components. We

735: -- list of kanban items (here if category set or item/category range is
736: -- is specified, then we impose extra where conditions and join a couple
737: -- of more tables as seen in the sql statement we just built). As we get
738: -- the inventory item id from mtl_system_items , we also get location
739: -- information for this item by joining to bom_inventory_components. We
740: -- are not satisfied with that. So we join bom_bill_of_materials
741: -- to get the assembly_item_id and its location information which is
742: -- (if its a kanban item) stored (hopefully) in mtl_kanban_pull_sequences
743: -- table. The catch here is that for a production kind of source type in

Line 826: 'bom_inventory_components mrp_bic, ' ||

822: 'mtl_system_items msi, ' ||
823: '( SELECT /*+ no_merge */ distinct inventory_item_id ,organization_id ' ||
824: ' FROM mtl_kanban_pull_sequences ' ||
825: ' WHERE kanban_plan_id = :b_PRODUCTION_KANBAN ) iv, ' ||
826: 'bom_inventory_components mrp_bic, ' ||
827: 'bom_bill_of_materials bbom, ' ||
828: 'mtl_kanban_pull_sequences ps, ' ||
829: l_additional_tables ||
830: 'mtl_system_items msi2 ' ||

Line 845: 'SELECT /+ INDEX(bic2 BOM_INVENTORY_COMPONENTS_N1) / '||

841: if (l_eco_profile = TRUE)
842: then
843: l_sql_stmt := l_sql_stmt ||
844: 'AND NOT EXISTS ( ' ||
845: 'SELECT /*+ INDEX(bic2 BOM_INVENTORY_COMPONENTS_N1) */ '||
846: 'NULL ' ||
847: 'FROM bom_inventory_components bic2 ' ||
848: 'WHERE bic2.bill_sequence_id = mrp_bic.bill_sequence_id ' ||
849: 'AND bic2.component_item_id = mrp_bic.component_item_id ' ||

Line 847: 'FROM bom_inventory_components bic2 ' ||

843: l_sql_stmt := l_sql_stmt ||
844: 'AND NOT EXISTS ( ' ||
845: 'SELECT /*+ INDEX(bic2 BOM_INVENTORY_COMPONENTS_N1) */ '||
846: 'NULL ' ||
847: 'FROM bom_inventory_components bic2 ' ||
848: 'WHERE bic2.bill_sequence_id = mrp_bic.bill_sequence_id ' ||
849: 'AND bic2.component_item_id = mrp_bic.component_item_id ' ||
850: 'AND (decode(bic2.implementation_date, null, ' ||
851: 'bic2.old_component_sequence_id, ' ||

Line 1029: bom_inventory_components mrp_bic,

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
1033: AND mllc.organization_id =

Line 1146: bom_inventory_components mrp_bic,

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
1150: AND mllc.organization_id =

Line 1160: SELECT /+ INDEX(bic2 BOM_INVENTORY_COMPONENTS_N1) /

1156: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1157: AND mrp_bic.effectivity_date <=
1158: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1159: AND NOT EXISTS (
1160: SELECT /*+ INDEX(bic2 BOM_INVENTORY_COMPONENTS_N1) */
1161: NULL
1162: FROM bom_inventory_components bic2
1163: WHERE bic2.bill_sequence_id = mrp_bic.bill_sequence_id
1164: AND bic2.component_item_id = mrp_bic.component_item_id

Line 1162: FROM bom_inventory_components bic2

1158: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1159: AND NOT EXISTS (
1160: SELECT /*+ INDEX(bic2 BOM_INVENTORY_COMPONENTS_N1) */
1161: NULL
1162: FROM bom_inventory_components bic2
1163: WHERE bic2.bill_sequence_id = mrp_bic.bill_sequence_id
1164: AND bic2.component_item_id = mrp_bic.component_item_id
1165: AND (decode(bic2.implementation_date, null,
1166: bic2.old_component_sequence_id,

Line 1271: -- bom_inventory_components and bom_operation_sequences are linked

1267: -- insert only to make the code a little cleaner. We tried doing
1268: -- this in the above sql statement itself but obviously if got
1269: -- kinda ugly trying to achieve it.
1270:
1271: -- bom_inventory_components and bom_operation_sequences are linked
1272: -- by the operation sequence number and for a particular operation
1273: -- sequence we have the net_planning_percent and the operation_yield
1274: -- (actually the reverse_cumulative_yield column) stored in
1275: -- bom_operation_sequences table

Line 1283: bom_inventory_components mrp_bic,

1279: (SELECT min(bos.reverse_cumulative_yield),
1280: min(bos.net_planning_percent)
1281: FROM bom_operation_sequences bos,
1282: bom_operational_routings bor,
1283: bom_inventory_components mrp_bic,
1284: bom_bill_of_materials bbom
1285: WHERE bbom.assembly_item_id = mllc.assembly_item_id
1286: AND bbom.organization_id = mllc.organization_id
1287: AND nvl(bbom.alternate_bom_designator, 'xxx') =

Line 1298: FROM bom_inventory_components bic2

1294: AND mrp_bic.effectivity_date <=
1295: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1296: AND NOT EXISTS (
1297: SELECT NULL
1298: FROM bom_inventory_components bic2
1299: WHERE bic2.bill_sequence_id = mrp_bic.bill_sequence_id
1300: AND bic2.component_item_id = mrp_bic.component_item_id
1301: AND (decode(bic2.implementation_date, null,
1302: bic2.old_component_sequence_id,