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

Line 554: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;

550: x_return_status OUT NOCOPY VARCHAR2)
551: IS
552:
553: l_total_quantity NUMBER;
554: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
555:
556: l_src_item_id mtl_system_items.inventory_item_id%TYPE;
557: l_src_organization_id mtl_parameters.organization_id%TYPE;
558: l_src_quantity NUMBER;

Line 556: l_src_item_id mtl_system_items.inventory_item_id%TYPE;

552:
553: l_total_quantity NUMBER;
554: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
555:
556: l_src_item_id mtl_system_items.inventory_item_id%TYPE;
557: l_src_organization_id mtl_parameters.organization_id%TYPE;
558: l_src_quantity NUMBER;
559: l_src_uom_code VARCHAR2(3);
560: l_src_primary_qty NUMBER;

Line 787: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE; -- Added for Bug 13896396

783: IS
784: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
785: l_owner_count number;
786: l_sub_type_rec csi_txn_sub_types%rowtype;
787: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE; -- Added for Bug 13896396
788: BEGIN
789:
790: x_return_status := fnd_api.g_ret_sts_success;
791:

Line 850: FROM mtl_system_items

846: -- Added for Bug 13896396
847: BEGIN
848: SELECT serial_number_control_code
849: INTO l_serial_control_code
850: FROM mtl_system_items
851: WHERE inventory_item_id = p_txn_line_dtl_tbl(l_td_ind).inventory_item_id
852: AND organization_id = p_txn_line_dtl_tbl(l_td_ind).INV_ORGANIZATION_ID;
853: EXCEPTION
854:

Line 1849: l_lot_control_code mtl_system_items.lot_control_code%TYPE;

1845: p_organization_id IN number,
1846: p_lot_number IN varchar2,
1847: x_return_status OUT NOCOPY varchar2)
1848: IS
1849: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1850: l_item_name mtl_system_items.segment1%TYPE;
1851: l_found char;
1852: BEGIN
1853:

Line 1850: l_item_name mtl_system_items.segment1%TYPE;

1846: p_lot_number IN varchar2,
1847: x_return_status OUT NOCOPY varchar2)
1848: IS
1849: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1850: l_item_name mtl_system_items.segment1%TYPE;
1851: l_found char;
1852: BEGIN
1853:
1854: x_return_status := fnd_api.g_ret_sts_success;

Line 1866: FROM mtl_system_items

1862: SELECT lot_control_code,
1863: segment1
1864: INTO l_lot_control_code,
1865: l_item_name
1866: FROM mtl_system_items
1867: WHERE inventory_item_id = p_inventory_item_id
1868: AND organization_id = p_organization_id;
1869: EXCEPTION
1870: WHEN no_data_found THEN

Line 1924: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;

1920: p_organization_id IN number,
1921: p_serial_number IN varchar2,
1922: x_return_status OUT NOCOPY varchar2)
1923: IS
1924: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
1925: l_item_name mtl_system_items.segment1%TYPE;
1926: l_found char;
1927: BEGIN
1928:

Line 1925: l_item_name mtl_system_items.segment1%TYPE;

1921: p_serial_number IN varchar2,
1922: x_return_status OUT NOCOPY varchar2)
1923: IS
1924: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
1925: l_item_name mtl_system_items.segment1%TYPE;
1926: l_found char;
1927: BEGIN
1928:
1929: x_return_status := fnd_api.g_ret_sts_success;

Line 1943: FROM mtl_system_items

1939: SELECT serial_number_control_code,
1940: segment1
1941: INTO l_serial_control_code,
1942: l_item_name
1943: FROM mtl_system_items
1944: WHERE inventory_item_id = p_inventory_item_id
1945: AND organization_id = p_organization_id;
1946: EXCEPTION
1947: