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.CSI_INV_TRXS_PKG dependencies on CSI_UTL_PKG

Line 3636: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893

3632: mmt.trx_source_line_id trx_source_line_id,
3633: mmt.move_order_line_id move_order_line_id,
3634: msib.serial_number_control_code serial_number_control_code,
3635: -- msib.lot_control_code lot_control_code,---- Commented for bug#14835893
3636: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893
3637: msib.revision_qty_control_code revision_qty_control_code,
3638: msib.comms_nl_trackable_flag comms_nl_trackable_flag,
3639: msib.location_control_code location_control_code,
3640: mmt.ship_to_location_id ship_to_location_id,

Line 3659: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),msib.lot_control_code) <>2 AND -- Added for bug#14835893

3655: mmt.transaction_id = p_transaction_id AND
3656: mmt.inventory_item_id = msib.inventory_item_id AND
3657: mmt.organization_id = msib.organization_id AND
3658: --msib.lot_control_code <> 2 AND
3659: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),msib.lot_control_code) <>2 AND -- Added for bug#14835893
3660: mmt.rcv_transaction_id = rt.transaction_id(+) AND
3661: mmt.organization_id = haou.organization_id(+) AND
3662: mmt.subinventory_code = msi.secondary_inventory_name(+) AND
3663: mmt.organization_id = msi.organization_id(+) AND

Line 3703: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893

3699: mmt.trx_source_line_id trx_source_line_id,
3700: mmt.move_order_line_id move_order_line_id,
3701: msib.serial_number_control_code serial_number_control_code,
3702: -- msib.lot_control_code lot_control_code,
3703: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893
3704: msib.revision_qty_control_code revision_qty_control_code,
3705: msib.comms_nl_trackable_flag comms_nl_trackable_flag,
3706: msib.location_control_code location_control_code,
3707: mmt.ship_to_location_id ship_to_location_id,

Line 3727: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),msib.lot_control_code) =2 AND -- Added for bug#14835893

3723: mmt.transaction_id = p_transaction_id AND
3724: mmt.inventory_item_id = msib.inventory_item_id AND
3725: mmt.organization_id = msib.organization_id AND
3726: -- msib.lot_control_code = 2 AND
3727: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),msib.lot_control_code) =2 AND -- Added for bug#14835893
3728: mmt.rcv_transaction_id = rt.transaction_id(+) AND
3729: mmt.organization_id = haou.organization_id(+) AND
3730: mmt.subinventory_code = msi.secondary_inventory_name(+) AND
3731: mmt.organization_id = msi.organization_id(+) AND