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 1030: bom_inventory_components mrp_bic,

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

Line 1147: bom_inventory_components mrp_bic,

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

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

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

Line 1163: FROM bom_inventory_components bic2

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

Line 1272: -- bom_inventory_components and bom_operation_sequences are linked

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

Line 1284: bom_inventory_components mrp_bic,

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

Line 1299: FROM bom_inventory_components bic2

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