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_PROCESS_TXN_PVT dependencies on MTL_SYSTEM_ITEMS

Line 468: l_serial_code mtl_system_items.serial_number_control_code%TYPE;

464: IS
465:
466: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;
467:
468: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
469: l_lot_code mtl_system_items.lot_control_code%TYPE;
470: l_locator_code mtl_system_items.location_control_code%TYPE;
471: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
472: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;

Line 469: l_lot_code mtl_system_items.lot_control_code%TYPE;

465:
466: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;
467:
468: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
469: l_lot_code mtl_system_items.lot_control_code%TYPE;
470: l_locator_code mtl_system_items.location_control_code%TYPE;
471: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
472: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
473: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;

Line 470: l_locator_code mtl_system_items.location_control_code%TYPE;

466: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;
467:
468: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
469: l_lot_code mtl_system_items.lot_control_code%TYPE;
470: l_locator_code mtl_system_items.location_control_code%TYPE;
471: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
472: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
473: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
474: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;

Line 471: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;

467:
468: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
469: l_lot_code mtl_system_items.lot_control_code%TYPE;
470: l_locator_code mtl_system_items.location_control_code%TYPE;
471: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
472: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
473: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
474: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
475: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;

Line 472: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;

468: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
469: l_lot_code mtl_system_items.lot_control_code%TYPE;
470: l_locator_code mtl_system_items.location_control_code%TYPE;
471: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
472: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
473: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
474: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
475: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
476: l_bom_item_type mtl_system_items.bom_item_type%TYPE;

Line 473: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;

469: l_lot_code mtl_system_items.lot_control_code%TYPE;
470: l_locator_code mtl_system_items.location_control_code%TYPE;
471: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
472: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
473: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
474: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
475: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
476: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
477: l_serial_tagged VARCHAR2(1) := 'N';

Line 474: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;

470: l_locator_code mtl_system_items.location_control_code%TYPE;
471: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
472: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
473: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
474: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
475: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
476: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
477: l_serial_tagged VARCHAR2(1) := 'N';
478:

Line 475: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;

471: l_revision_code mtl_system_items.revision_qty_control_code%TYPE;
472: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
473: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
474: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
475: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
476: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
477: l_serial_tagged VARCHAR2(1) := 'N';
478:
479: BEGIN

Line 476: l_bom_item_type mtl_system_items.bom_item_type%TYPE;

472: l_ib_trackable_flag mtl_system_items.comms_nl_trackable_flag%TYPE;
473: l_shippable_flag mtl_system_items.shippable_item_flag%TYPE;
474: l_inv_item_flag mtl_system_items.inventory_item_flag%TYPE;
475: l_stockable_flag mtl_system_items.stock_enabled_flag%TYPE;
476: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
477: l_serial_tagged VARCHAR2(1) := 'N';
478:
479: BEGIN
480:

Line 508: FROM mtl_system_items_kfv

504: l_shippable_flag,
505: l_inv_item_flag,
506: l_stockable_flag,
507: l_bom_item_type
508: FROM mtl_system_items_kfv
509: WHERE inventory_item_id = p_inventory_item_id
510: AND organization_id = p_organization_id;
511:
512: EXCEPTION