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_DEFAULT_TROLIN SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 78


        SELECT  MTL_TXN_REQUEST_LINES_S.NEXTVAL
        INTO    l_line_id
        FROM    DUAL;

Line: 112


		SELECT nvl(max(line_number), 0)
		INTO   l_max_line_num
		FROM   mtl_txn_request_lines_v
		WHERE  header_id = g_trolin_rec.header_id;

Line: 410


    select transaction_source_type_id
    into l_transaction_source_type_id
    from mtl_transaction_types
    where transaction_type_id = p_transaction_type_id;

Line: 570


       SELECT primary_uom_code, secondary_uom_code,tracking_quantity_ind, secondary_default_ind
         INTO p_trolin_rec.uom_code,
              p_trolin_rec.secondary_uom,
              l_tracking_quantity_ind,
              l_secondary_default_ind
         FROM mtl_system_items
        WHERE inventory_item_id = p_trolin_rec.inventory_item_id
          AND organization_id = p_trolin_rec.organization_id;

Line: 685


	select project_id,task_id
	into g_trolin_rec.project_id,g_trolin_rec.task_id
	from mtl_item_locations
	where inventory_location_id = g_trolin_rec.to_locator_id;

Line: 936


	   SELECT move_order_type INTO l_mov_order_type
	     FROM   mtl_txn_request_headers
	     WHERE header_id=g_trolin_rec.header_id;

Line: 1705


    IF g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_trolin_rec.last_updated_by := NULL;

Line: 1711


    IF g_trolin_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_trolin_rec.last_update_date := NULL;

Line: 1717


    IF g_trolin_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_trolin_rec.last_update_login := NULL;

Line: 1735


    IF g_trolin_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_trolin_rec.program_update_date := NULL;

Line: 1773


    OR  g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_trolin_rec.line_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.line_number = FND_API.G_MISS_NUM
    OR  g_trolin_rec.line_status = FND_API.G_MISS_NUM
    OR  g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
    OR  g_trolin_rec.organization_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.program_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_trolin_rec.project_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.quantity = FND_API.G_MISS_NUM
    OR  g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
    OR  g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
    OR  g_trolin_rec.reason_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.reference = FND_API.G_MISS_CHAR
    OR  g_trolin_rec.reference_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
    OR  g_trolin_rec.request_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.revision = FND_API.G_MISS_CHAR
    OR  g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
    OR  g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
    OR  g_trolin_rec.status_date = FND_API.G_MISS_DATE
    OR  g_trolin_rec.task_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
    OR  g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
    OR  g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
    OR  g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
    OR  g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
    OR  g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
    OR  g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
--INVCONV
    OR  g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
    OR  g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
    OR  g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM
    OR  g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM
    OR  g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM
--INVCONV
    THEN

        INV_Default_Trolin.Attributes
        (   p_trolin_rec                  => g_trolin_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_trolin_rec                  => x_trolin_rec
        );