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.WIP_BFLPROC_PRIV dependencies on MTL_SYSTEM_ITEMS

Line 91: mtl_system_items_b msi

87: -1 * mti.transaction_quantity txnQty, --make qty relative to wip (relative to inv in table)
88: msi.lot_control_code lotControlCode,
89: msi.serial_number_control_code serialNumControlCode
90: from mtl_transactions_interface mti,
91: mtl_system_items_b msi
92: where mti.transaction_header_id = p_txnHdrID
93: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
94: wip_constants.issnegc_action, wip_constants.retnegc_action)
95: and mti.operation_seq_num between p_firstOp and p_lastOp

Line 149: mtl_system_items_kfv msi,

145: msi.location_control_code,
146: mil.project_id,
147: mil.task_id
148: from wip_requirement_operations wro,
149: mtl_system_items_kfv msi,
150: wip_operations wo,
151: mtl_item_locations_kfv milk,
152: wip_discrete_jobs wdj,
153: mtl_parameters mp,

Line 216: mtl_system_items_kfv msi,

212: mil.task_id
213: from wip_requirement_operations wro,
214: wip_repetitive_schedules wrs,
215: wip_repetitive_items wri,
216: mtl_system_items_kfv msi,
217: wip_operations wo,
218: mtl_item_locations_kfv milk,
219: mtl_parameters mp,
220: -- Fixed bug 4692413. We should not refer to column in kfv directly.

Line 927: mtl_system_items msi

923: be.plan_level bomLevel, --level of nesting. 1 is a top level component
924: bic.basis_type /* LBM Project */
925: from bom_explosion_temp be,
926: bom_inventory_components bic,
927: mtl_system_items msi
928: where be.group_id = v_grpID
929: and be.component_sequence_id = bic.component_sequence_id
930: and be.component_item_id = msi.inventory_item_id
931: and be.component_item_id <> p_itemID --exclude assy if it is in the table

Line 968: mtl_system_items_kfv msi,

964: 2,milk.concatenated_segments,
965: 1, inv_project.get_pjm_locsegs(milk.concatenated_segments)) locatorName
966: from bom_explosion_temp be,
967: bom_inventory_components bic,
968: mtl_system_items_kfv msi,
969: mtl_item_locations_kfv milk,
970: mtl_parameters mp
971: where be.group_id = v_grpID
972: and be.component_sequence_id = bic.component_sequence_id

Line 1125: from bom_parameters bp, mtl_system_items_b msi

1121: into l_inheritPhOpSeq,
1122: l_grpID,
1123: l_bomItemType,
1124: l_maxBomLevel
1125: from bom_parameters bp, mtl_system_items_b msi
1126: where bp.organization_id = p_orgID
1127: and bp.organization_id = msi.organization_id
1128: and msi.inventory_item_id = p_itemID;
1129: exception

Line 2720: mtl_system_items msi

2716: /*
2717: SELECT COUNT(*)
2718: INTO l_lot_ser_count
2719: FROM mtl_transactions_interface mti,
2720: mtl_system_items msi
2721: WHERE mti.organization_id = msi.organization_id
2722: AND mti.inventory_item_id = msi.inventory_item_id
2723: AND (msi.lot_control_code = WIP_CONSTANTS.LOT
2724: OR

Line 2737: mtl_system_items msi

2733: --Updated as per Bug#9544120
2734: SELECT COUNT(*)
2735: INTO l_lot_ser_count
2736: FROM mtl_transactions_interface mti,
2737: mtl_system_items msi
2738: WHERE mti.organization_id = msi.organization_id
2739: AND mti.inventory_item_id = msi.inventory_item_id
2740: AND (msi.lot_control_code = WIP_CONSTANTS.LOT
2741: OR

Line 2868: FROM mtl_system_items_kfv msik,

2864: msik.lot_control_code,
2865: msik.serial_number_control_code,
2866: msik.inventory_asset_flag,
2867: mmtt.transaction_quantity
2868: FROM mtl_system_items_kfv msik,
2869: mtl_units_of_measure muom
2870: WHERE mmtt.organization_id = msik.organization_id
2871: AND mmtt.inventory_item_id = msik.inventory_item_id
2872: AND msik.primary_uom_code = muom.uom_code)