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.INV_LABEL_PVT10 dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 11: /* MMTT_TYPE : transaction is MTL_MATERIAL_TRANSACTIONS_TEMP ID */

7: VARIABLE_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);
8: TAG_E CONSTANT VARCHAR2(50) := '>'||fnd_global.local_chr(10);
9: l_debug number;
10:
11: /* MMTT_TYPE : transaction is MTL_MATERIAL_TRANSACTIONS_TEMP ID */
12: /* MTI_TYPE : transaction is MTL_TRANSACTION_INTERFACE ID */
13: /* MTRL_TYPE : transaction is MTL_TXN_REQUEST_LINES ID */
14: /* WFS_TYPE : transaction is WIP_FLOW_SCHEDULES ID */
15:

Line 1769: ,p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

1765: ,x_msg_data OUT NOCOPY VARCHAR2
1766: ,x_return_status OUT NOCOPY VARCHAR2
1767: ,p_label_type_info IN INV_LABEL.label_type_rec
1768: ,p_transaction_id IN NUMBER
1769: ,p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
1770: ,p_transaction_identifier IN NUMBER
1771: ) IS
1772:
1773: l_api_name VARCHAR2(20) := 'get_variable_data';

Line 1778: l_transaction_id MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TEMP_ID%TYPE;

1774: SERIAL_EXCEPTION EXCEPTION;
1775: NO_FLOW_DATA_FOUND_X EXCEPTION;
1776: NO_LABEL_FORMAT_FOUND_X EXCEPTION;
1777:
1778: l_transaction_id MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TEMP_ID%TYPE;
1779:
1780: TYPE inptype is RECORD
1781: (
1782: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,

Line 1782: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,

1778: l_transaction_id MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TEMP_ID%TYPE;
1779:
1780: TYPE inptype is RECORD
1781: (
1782: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1783: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1784: subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1785: locator_id mtl_material_transactions_temp.locator_id%TYPE,
1786: lot_number mtl_material_transactions_temp.lot_number%TYPE,

Line 1783: organization_id mtl_material_transactions_temp.organization_id%TYPE,

1779:
1780: TYPE inptype is RECORD
1781: (
1782: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1783: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1784: subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1785: locator_id mtl_material_transactions_temp.locator_id%TYPE,
1786: lot_number mtl_material_transactions_temp.lot_number%TYPE,
1787: serial_number mtl_material_transactions_temp.serial_number%TYPE,

Line 1784: subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,

1780: TYPE inptype is RECORD
1781: (
1782: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1783: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1784: subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1785: locator_id mtl_material_transactions_temp.locator_id%TYPE,
1786: lot_number mtl_material_transactions_temp.lot_number%TYPE,
1787: serial_number mtl_material_transactions_temp.serial_number%TYPE,
1788: serial_number_start mtl_serial_numbers.serial_number%TYPE,

Line 1785: locator_id mtl_material_transactions_temp.locator_id%TYPE,

1781: (
1782: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1783: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1784: subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1785: locator_id mtl_material_transactions_temp.locator_id%TYPE,
1786: lot_number mtl_material_transactions_temp.lot_number%TYPE,
1787: serial_number mtl_material_transactions_temp.serial_number%TYPE,
1788: serial_number_start mtl_serial_numbers.serial_number%TYPE,
1789: serial_number_end mtl_serial_numbers.serial_number%TYPE,

Line 1786: lot_number mtl_material_transactions_temp.lot_number%TYPE,

1782: inventory_item_id mtl_material_transactions_temp.inventory_item_id%TYPE,
1783: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1784: subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1785: locator_id mtl_material_transactions_temp.locator_id%TYPE,
1786: lot_number mtl_material_transactions_temp.lot_number%TYPE,
1787: serial_number mtl_material_transactions_temp.serial_number%TYPE,
1788: serial_number_start mtl_serial_numbers.serial_number%TYPE,
1789: serial_number_end mtl_serial_numbers.serial_number%TYPE,
1790: cost_group_id mtl_material_transactions_temp.cost_group_id%TYPE,

Line 1787: serial_number mtl_material_transactions_temp.serial_number%TYPE,

1783: organization_id mtl_material_transactions_temp.organization_id%TYPE,
1784: subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1785: locator_id mtl_material_transactions_temp.locator_id%TYPE,
1786: lot_number mtl_material_transactions_temp.lot_number%TYPE,
1787: serial_number mtl_material_transactions_temp.serial_number%TYPE,
1788: serial_number_start mtl_serial_numbers.serial_number%TYPE,
1789: serial_number_end mtl_serial_numbers.serial_number%TYPE,
1790: cost_group_id mtl_material_transactions_temp.cost_group_id%TYPE,
1791: project_id mtl_material_transactions_temp.project_id%TYPE,

Line 1790: cost_group_id mtl_material_transactions_temp.cost_group_id%TYPE,

1786: lot_number mtl_material_transactions_temp.lot_number%TYPE,
1787: serial_number mtl_material_transactions_temp.serial_number%TYPE,
1788: serial_number_start mtl_serial_numbers.serial_number%TYPE,
1789: serial_number_end mtl_serial_numbers.serial_number%TYPE,
1790: cost_group_id mtl_material_transactions_temp.cost_group_id%TYPE,
1791: project_id mtl_material_transactions_temp.project_id%TYPE,
1792: task_id mtl_material_transactions_temp.task_id%TYPE,
1793: quantity mtl_material_transactions_temp.transaction_quantity%TYPE,
1794: uom mtl_material_transactions_temp.transaction_uom%TYPE,

Line 1791: project_id mtl_material_transactions_temp.project_id%TYPE,

1787: serial_number mtl_material_transactions_temp.serial_number%TYPE,
1788: serial_number_start mtl_serial_numbers.serial_number%TYPE,
1789: serial_number_end mtl_serial_numbers.serial_number%TYPE,
1790: cost_group_id mtl_material_transactions_temp.cost_group_id%TYPE,
1791: project_id mtl_material_transactions_temp.project_id%TYPE,
1792: task_id mtl_material_transactions_temp.task_id%TYPE,
1793: quantity mtl_material_transactions_temp.transaction_quantity%TYPE,
1794: uom mtl_material_transactions_temp.transaction_uom%TYPE,
1795: revision mtl_material_transactions_temp.revision%TYPE,

Line 1792: task_id mtl_material_transactions_temp.task_id%TYPE,

1788: serial_number_start mtl_serial_numbers.serial_number%TYPE,
1789: serial_number_end mtl_serial_numbers.serial_number%TYPE,
1790: cost_group_id mtl_material_transactions_temp.cost_group_id%TYPE,
1791: project_id mtl_material_transactions_temp.project_id%TYPE,
1792: task_id mtl_material_transactions_temp.task_id%TYPE,
1793: quantity mtl_material_transactions_temp.transaction_quantity%TYPE,
1794: uom mtl_material_transactions_temp.transaction_uom%TYPE,
1795: revision mtl_material_transactions_temp.revision%TYPE,
1796: alternate_bom_designator mtl_material_transactions_temp.alternate_bom_designator%TYPE,

Line 1793: quantity mtl_material_transactions_temp.transaction_quantity%TYPE,

1789: serial_number_end mtl_serial_numbers.serial_number%TYPE,
1790: cost_group_id mtl_material_transactions_temp.cost_group_id%TYPE,
1791: project_id mtl_material_transactions_temp.project_id%TYPE,
1792: task_id mtl_material_transactions_temp.task_id%TYPE,
1793: quantity mtl_material_transactions_temp.transaction_quantity%TYPE,
1794: uom mtl_material_transactions_temp.transaction_uom%TYPE,
1795: revision mtl_material_transactions_temp.revision%TYPE,
1796: alternate_bom_designator mtl_material_transactions_temp.alternate_bom_designator%TYPE,
1797: alternate_routing_designator mtl_material_transactions_temp.alternate_routing_designator%TYPE,

Line 1794: uom mtl_material_transactions_temp.transaction_uom%TYPE,

1790: cost_group_id mtl_material_transactions_temp.cost_group_id%TYPE,
1791: project_id mtl_material_transactions_temp.project_id%TYPE,
1792: task_id mtl_material_transactions_temp.task_id%TYPE,
1793: quantity mtl_material_transactions_temp.transaction_quantity%TYPE,
1794: uom mtl_material_transactions_temp.transaction_uom%TYPE,
1795: revision mtl_material_transactions_temp.revision%TYPE,
1796: alternate_bom_designator mtl_material_transactions_temp.alternate_bom_designator%TYPE,
1797: alternate_routing_designator mtl_material_transactions_temp.alternate_routing_designator%TYPE,
1798: sale_header_id mtl_material_transactions_temp.demand_source_header_id%TYPE,

Line 1795: revision mtl_material_transactions_temp.revision%TYPE,

1791: project_id mtl_material_transactions_temp.project_id%TYPE,
1792: task_id mtl_material_transactions_temp.task_id%TYPE,
1793: quantity mtl_material_transactions_temp.transaction_quantity%TYPE,
1794: uom mtl_material_transactions_temp.transaction_uom%TYPE,
1795: revision mtl_material_transactions_temp.revision%TYPE,
1796: alternate_bom_designator mtl_material_transactions_temp.alternate_bom_designator%TYPE,
1797: alternate_routing_designator mtl_material_transactions_temp.alternate_routing_designator%TYPE,
1798: sale_header_id mtl_material_transactions_temp.demand_source_header_id%TYPE,
1799: sale_line_id mtl_material_transactions_temp.demand_source_line%TYPE,

Line 1796: alternate_bom_designator mtl_material_transactions_temp.alternate_bom_designator%TYPE,

1792: task_id mtl_material_transactions_temp.task_id%TYPE,
1793: quantity mtl_material_transactions_temp.transaction_quantity%TYPE,
1794: uom mtl_material_transactions_temp.transaction_uom%TYPE,
1795: revision mtl_material_transactions_temp.revision%TYPE,
1796: alternate_bom_designator mtl_material_transactions_temp.alternate_bom_designator%TYPE,
1797: alternate_routing_designator mtl_material_transactions_temp.alternate_routing_designator%TYPE,
1798: sale_header_id mtl_material_transactions_temp.demand_source_header_id%TYPE,
1799: sale_line_id mtl_material_transactions_temp.demand_source_line%TYPE,
1800: kanban_card_id mtl_material_transactions_temp.kanban_card_id%TYPE,

Line 1797: alternate_routing_designator mtl_material_transactions_temp.alternate_routing_designator%TYPE,

1793: quantity mtl_material_transactions_temp.transaction_quantity%TYPE,
1794: uom mtl_material_transactions_temp.transaction_uom%TYPE,
1795: revision mtl_material_transactions_temp.revision%TYPE,
1796: alternate_bom_designator mtl_material_transactions_temp.alternate_bom_designator%TYPE,
1797: alternate_routing_designator mtl_material_transactions_temp.alternate_routing_designator%TYPE,
1798: sale_header_id mtl_material_transactions_temp.demand_source_header_id%TYPE,
1799: sale_line_id mtl_material_transactions_temp.demand_source_line%TYPE,
1800: kanban_card_id mtl_material_transactions_temp.kanban_card_id%TYPE,
1801: lpn_id mtl_material_transactions_temp.lpn_id%TYPE,

Line 1798: sale_header_id mtl_material_transactions_temp.demand_source_header_id%TYPE,

1794: uom mtl_material_transactions_temp.transaction_uom%TYPE,
1795: revision mtl_material_transactions_temp.revision%TYPE,
1796: alternate_bom_designator mtl_material_transactions_temp.alternate_bom_designator%TYPE,
1797: alternate_routing_designator mtl_material_transactions_temp.alternate_routing_designator%TYPE,
1798: sale_header_id mtl_material_transactions_temp.demand_source_header_id%TYPE,
1799: sale_line_id mtl_material_transactions_temp.demand_source_line%TYPE,
1800: kanban_card_id mtl_material_transactions_temp.kanban_card_id%TYPE,
1801: lpn_id mtl_material_transactions_temp.lpn_id%TYPE,
1802: wip_entity_id mtl_material_transactions_temp.transaction_source_id%TYPE,

Line 1799: sale_line_id mtl_material_transactions_temp.demand_source_line%TYPE,

1795: revision mtl_material_transactions_temp.revision%TYPE,
1796: alternate_bom_designator mtl_material_transactions_temp.alternate_bom_designator%TYPE,
1797: alternate_routing_designator mtl_material_transactions_temp.alternate_routing_designator%TYPE,
1798: sale_header_id mtl_material_transactions_temp.demand_source_header_id%TYPE,
1799: sale_line_id mtl_material_transactions_temp.demand_source_line%TYPE,
1800: kanban_card_id mtl_material_transactions_temp.kanban_card_id%TYPE,
1801: lpn_id mtl_material_transactions_temp.lpn_id%TYPE,
1802: wip_entity_id mtl_material_transactions_temp.transaction_source_id%TYPE,
1803: schedule_number wip_flow_schedules.schedule_number%TYPE,

Line 1800: kanban_card_id mtl_material_transactions_temp.kanban_card_id%TYPE,

1796: alternate_bom_designator mtl_material_transactions_temp.alternate_bom_designator%TYPE,
1797: alternate_routing_designator mtl_material_transactions_temp.alternate_routing_designator%TYPE,
1798: sale_header_id mtl_material_transactions_temp.demand_source_header_id%TYPE,
1799: sale_line_id mtl_material_transactions_temp.demand_source_line%TYPE,
1800: kanban_card_id mtl_material_transactions_temp.kanban_card_id%TYPE,
1801: lpn_id mtl_material_transactions_temp.lpn_id%TYPE,
1802: wip_entity_id mtl_material_transactions_temp.transaction_source_id%TYPE,
1803: schedule_number wip_flow_schedules.schedule_number%TYPE,
1804: lot_control_code mtl_system_items.lot_control_code%TYPE,

Line 1801: lpn_id mtl_material_transactions_temp.lpn_id%TYPE,

1797: alternate_routing_designator mtl_material_transactions_temp.alternate_routing_designator%TYPE,
1798: sale_header_id mtl_material_transactions_temp.demand_source_header_id%TYPE,
1799: sale_line_id mtl_material_transactions_temp.demand_source_line%TYPE,
1800: kanban_card_id mtl_material_transactions_temp.kanban_card_id%TYPE,
1801: lpn_id mtl_material_transactions_temp.lpn_id%TYPE,
1802: wip_entity_id mtl_material_transactions_temp.transaction_source_id%TYPE,
1803: schedule_number wip_flow_schedules.schedule_number%TYPE,
1804: lot_control_code mtl_system_items.lot_control_code%TYPE,
1805: serial_number_control_code mtl_system_items.serial_number_control_code%TYPE,

Line 1802: wip_entity_id mtl_material_transactions_temp.transaction_source_id%TYPE,

1798: sale_header_id mtl_material_transactions_temp.demand_source_header_id%TYPE,
1799: sale_line_id mtl_material_transactions_temp.demand_source_line%TYPE,
1800: kanban_card_id mtl_material_transactions_temp.kanban_card_id%TYPE,
1801: lpn_id mtl_material_transactions_temp.lpn_id%TYPE,
1802: wip_entity_id mtl_material_transactions_temp.transaction_source_id%TYPE,
1803: schedule_number wip_flow_schedules.schedule_number%TYPE,
1804: lot_control_code mtl_system_items.lot_control_code%TYPE,
1805: serial_number_control_code mtl_system_items.serial_number_control_code%TYPE,
1806: transaction_id mtl_material_transactions_temp.transaction_temp_id%TYPE

Line 1806: transaction_id mtl_material_transactions_temp.transaction_temp_id%TYPE

1802: wip_entity_id mtl_material_transactions_temp.transaction_source_id%TYPE,
1803: schedule_number wip_flow_schedules.schedule_number%TYPE,
1804: lot_control_code mtl_system_items.lot_control_code%TYPE,
1805: serial_number_control_code mtl_system_items.serial_number_control_code%TYPE,
1806: transaction_id mtl_material_transactions_temp.transaction_temp_id%TYPE
1807: );
1808:
1809:
1810: --TYPE flow_input_tbl_type IS TABLE OF inptype INDEX BY BINARY_INTEGER;

Line 1876: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,

1872: NVL(mmtt.schedule_number, wfs.schedule_number) schedule_number,
1873: msi.lot_control_code,
1874: msi.serial_number_control_code serial_number_control_code,
1875: mmtt.transaction_temp_id transaction_id
1876: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
1877: MTL_TRANSACTION_LOTS_TEMP mtlt,
1878: MTL_SYSTEM_ITEMS msi,
1879: WIP_ENTITIES WE,
1880: WIP_FLOW_SCHEDULES wfs

Line 1923: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,

1919: NVL(mmtt.schedule_number, wfs.schedule_number) schedule_number,
1920: msi.lot_control_code,
1921: msi.serial_number_control_code serial_number_control_code,
1922: mmtt.transaction_temp_id transaction_id
1923: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
1924: MTL_TRANSACTION_LOTS_TEMP mtlt,
1925: MTL_SYSTEM_ITEMS msi,
1926: WIP_ENTITIES WE,
1927: WIP_FLOW_SCHEDULES wfs,

Line 1928: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt_orig

1924: MTL_TRANSACTION_LOTS_TEMP mtlt,
1925: MTL_SYSTEM_ITEMS msi,
1926: WIP_ENTITIES WE,
1927: WIP_FLOW_SCHEDULES wfs,
1928: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt_orig
1929: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1930: AND mmtt.organization_id = msi.organization_id
1931: AND mmtt.inventory_item_id = msi.inventory_item_id
1932: AND mmtt.transaction_source_id = wfs.wip_entity_id(+)

Line 2020: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,

2016: msi.lot_control_code,
2017: msi.serial_number_control_code,
2018: mmtt.transaction_temp_id transaction_id
2019: FROM MTL_TXN_REQUEST_LINES mtrl,
2020: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
2021: MTL_TRANSACTION_LOTS_TEMP mtlt,
2022: MTL_SYSTEM_ITEMS msi,
2023: WIP_ENTITIES WE
2024: WHERE mtrl.line_id = l_transaction_id

Line 2062: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,

2058: msi.lot_control_code,
2059: msi.serial_number_control_code,
2060: mmtt.transaction_temp_id transaction_id
2061: FROM WIP_FLOW_SCHEDULES wfs,
2062: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
2063: MTL_TRANSACTION_LOTS_TEMP mtlt,
2064: MTL_SYSTEM_ITEMS msi,
2065: WIP_ENTITIES WE
2066: WHERE mmtt.transaction_source_type_id = 5

Line 2167: * mtl_material_transactions_temp and lpn_id in mtl_serial_numbers.

2163: *
2164: * Currently the cursor is fetching data using mtl_serial_numbers_temp table.
2165: * whereas the data will present only on mtl_serial_numbers table.
2166: * hence, modified the code to retrieve the serial numbers based on lpn_id in
2167: * mtl_material_transactions_temp and lpn_id in mtl_serial_numbers.
2168:
2169: -- Bug 2882958, added parameter p_lot_number to restrict on lot
2170: CURSOR mmtt_serial_curs(p_lot_number VARCHAR2) IS
2171: -- Serial Control

Line 2173: FROM mtl_material_transactions_temp mmtt,

2169: -- Bug 2882958, added parameter p_lot_number to restrict on lot
2170: CURSOR mmtt_serial_curs(p_lot_number VARCHAR2) IS
2171: -- Serial Control
2172: SELECT msn.serial_number
2173: FROM mtl_material_transactions_temp mmtt,
2174: mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
2175: where mmtt.transaction_temp_id = msnt.transaction_temp_id
2176: and msnt.fm_serial_number <= msn.serial_number AND
2177: msnt.to_serial_number >= msn.serial_number

Line 2184: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt,

2180: and mmtt.transaction_temp_id = l_transaction_id
2181: UNION
2182: -- Lot and Serial Control
2183: SELECT msn.serial_number
2184: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt,
2185: mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
2186: where mmtt.transaction_temp_id = mtlt.transaction_temp_id
2187: and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
2188: and msnt.fm_serial_number <= msn.serial_number AND

Line 2198: FROM mtl_material_transactions_temp mmtt,

2194: and mtlt.lot_number = p_lot_number; */
2195:
2196: CURSOR mmtt_serial_curs(p_lot_number VARCHAR2) IS
2197: SELECT msn.serial_number
2198: FROM mtl_material_transactions_temp mmtt,
2199: mtl_serial_numbers msn
2200: where mmtt.transaction_temp_id = l_transaction_id
2201: and (mmtt.lpn_id = msn.lpn_id
2202: or mmtt.content_lpn_id = msn.lpn_id) -- Modified for the bug # 5740354

Line 2206: FROM mtl_material_transactions_temp mmtt,

2202: or mmtt.content_lpn_id = msn.lpn_id) -- Modified for the bug # 5740354
2203: and mmtt.inventory_item_id = msn.inventory_item_id
2204: UNION
2205: SELECT msn.serial_number
2206: FROM mtl_material_transactions_temp mmtt,
2207: mtl_serial_numbers msn
2208: where mmtt.transaction_temp_id = l_transaction_id
2209: and (mmtt.lpn_id = msn.lpn_id
2210: or mmtt.content_lpn_id = msn.lpn_id) -- Modified for the bug # 5740354

Line 2263: l_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE;

2259: l_lot_number VARCHAR2(80) := null;
2260: l_cost_group_id NUMBER := null;
2261: l_quantity NUMBER := null;
2262: l_uom VARCHAR2(3) := null;
2263: l_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE;
2264:
2265:
2266: l_selected_fields INV_LABEL.label_field_variable_tbl_type;
2267: l_selected_fields_count NUMBER;