DBA Data[Home] [Help]

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 1822: l_lot_control_code mtl_system_items.lot_control_code%TYPE;

1818: p_organization_id IN number,
1819: p_lot_number IN varchar2,
1820: x_return_status OUT NOCOPY varchar2)
1821: IS
1822: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1823: l_item_name mtl_system_items.segment1%TYPE;
1824: l_found char;
1825: BEGIN
1826:

Line 1823: l_item_name mtl_system_items.segment1%TYPE;

1819: p_lot_number IN varchar2,
1820: x_return_status OUT NOCOPY varchar2)
1821: IS
1822: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1823: l_item_name mtl_system_items.segment1%TYPE;
1824: l_found char;
1825: BEGIN
1826:
1827: x_return_status := fnd_api.g_ret_sts_success;

Line 1839: FROM mtl_system_items

1835: SELECT lot_control_code,
1836: segment1
1837: INTO l_lot_control_code,
1838: l_item_name
1839: FROM mtl_system_items
1840: WHERE inventory_item_id = p_inventory_item_id
1841: AND organization_id = p_organization_id;
1842: EXCEPTION
1843: WHEN no_data_found THEN

Line 1897: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;

1893: p_organization_id IN number,
1894: p_serial_number IN varchar2,
1895: x_return_status OUT NOCOPY varchar2)
1896: IS
1897: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
1898: l_item_name mtl_system_items.segment1%TYPE;
1899: l_found char;
1900: BEGIN
1901:

Line 1898: l_item_name mtl_system_items.segment1%TYPE;

1894: p_serial_number IN varchar2,
1895: x_return_status OUT NOCOPY varchar2)
1896: IS
1897: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
1898: l_item_name mtl_system_items.segment1%TYPE;
1899: l_found char;
1900: BEGIN
1901:
1902: x_return_status := fnd_api.g_ret_sts_success;

Line 1916: FROM mtl_system_items

1912: SELECT serial_number_control_code,
1913: segment1
1914: INTO l_serial_control_code,
1915: l_item_name
1916: FROM mtl_system_items
1917: WHERE inventory_item_id = p_inventory_item_id
1918: AND organization_id = p_organization_id;
1919: EXCEPTION
1920: