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_COPY_ITEM_CP dependencies on MTL_SYSTEM_ITEMS_B

Line 561: -- Define a record type to contain required details from mtl_system_items_b.

557: l_cost_of_sales_account mtl_parameters.cost_of_sales_account%TYPE;
558: l_encumbrance_account mtl_parameters.encumbrance_account%TYPE;
559: l_process_flag mtl_item_revisions_interface.process_flag%TYPE; --myerrams, Bug: 4892069
560:
561: -- Define a record type to contain required details from mtl_system_items_b.
562: TYPE mtl_system_items_rec IS RECORD
563: ( inventory_item_id mtl_system_items_b.inventory_item_id%Type
564: , purchasing_enabled_flag mtl_system_items_b.purchasing_enabled_flag%Type
565: , customer_order_enabled_flag mtl_system_items_b.customer_order_enabled_flag%Type

Line 563: ( inventory_item_id mtl_system_items_b.inventory_item_id%Type

559: l_process_flag mtl_item_revisions_interface.process_flag%TYPE; --myerrams, Bug: 4892069
560:
561: -- Define a record type to contain required details from mtl_system_items_b.
562: TYPE mtl_system_items_rec IS RECORD
563: ( inventory_item_id mtl_system_items_b.inventory_item_id%Type
564: , purchasing_enabled_flag mtl_system_items_b.purchasing_enabled_flag%Type
565: , customer_order_enabled_flag mtl_system_items_b.customer_order_enabled_flag%Type
566: , internal_order_enabled_flag mtl_system_items_b.internal_order_enabled_flag%Type
567: , mtl_transactions_enabled_flag mtl_system_items_b.mtl_transactions_enabled_flag%Type

Line 564: , purchasing_enabled_flag mtl_system_items_b.purchasing_enabled_flag%Type

560:
561: -- Define a record type to contain required details from mtl_system_items_b.
562: TYPE mtl_system_items_rec IS RECORD
563: ( inventory_item_id mtl_system_items_b.inventory_item_id%Type
564: , purchasing_enabled_flag mtl_system_items_b.purchasing_enabled_flag%Type
565: , customer_order_enabled_flag mtl_system_items_b.customer_order_enabled_flag%Type
566: , internal_order_enabled_flag mtl_system_items_b.internal_order_enabled_flag%Type
567: , mtl_transactions_enabled_flag mtl_system_items_b.mtl_transactions_enabled_flag%Type
568: , stock_enabled_flag mtl_system_items_b.stock_enabled_flag%Type

Line 565: , customer_order_enabled_flag mtl_system_items_b.customer_order_enabled_flag%Type

561: -- Define a record type to contain required details from mtl_system_items_b.
562: TYPE mtl_system_items_rec IS RECORD
563: ( inventory_item_id mtl_system_items_b.inventory_item_id%Type
564: , purchasing_enabled_flag mtl_system_items_b.purchasing_enabled_flag%Type
565: , customer_order_enabled_flag mtl_system_items_b.customer_order_enabled_flag%Type
566: , internal_order_enabled_flag mtl_system_items_b.internal_order_enabled_flag%Type
567: , mtl_transactions_enabled_flag mtl_system_items_b.mtl_transactions_enabled_flag%Type
568: , stock_enabled_flag mtl_system_items_b.stock_enabled_flag%Type
569: , bom_enabled_flag mtl_system_items_b.bom_enabled_flag%Type

Line 566: , internal_order_enabled_flag mtl_system_items_b.internal_order_enabled_flag%Type

562: TYPE mtl_system_items_rec IS RECORD
563: ( inventory_item_id mtl_system_items_b.inventory_item_id%Type
564: , purchasing_enabled_flag mtl_system_items_b.purchasing_enabled_flag%Type
565: , customer_order_enabled_flag mtl_system_items_b.customer_order_enabled_flag%Type
566: , internal_order_enabled_flag mtl_system_items_b.internal_order_enabled_flag%Type
567: , mtl_transactions_enabled_flag mtl_system_items_b.mtl_transactions_enabled_flag%Type
568: , stock_enabled_flag mtl_system_items_b.stock_enabled_flag%Type
569: , bom_enabled_flag mtl_system_items_b.bom_enabled_flag%Type
570: , build_in_wip_flag mtl_system_items_b.build_in_wip_flag%Type

Line 567: , mtl_transactions_enabled_flag mtl_system_items_b.mtl_transactions_enabled_flag%Type

563: ( inventory_item_id mtl_system_items_b.inventory_item_id%Type
564: , purchasing_enabled_flag mtl_system_items_b.purchasing_enabled_flag%Type
565: , customer_order_enabled_flag mtl_system_items_b.customer_order_enabled_flag%Type
566: , internal_order_enabled_flag mtl_system_items_b.internal_order_enabled_flag%Type
567: , mtl_transactions_enabled_flag mtl_system_items_b.mtl_transactions_enabled_flag%Type
568: , stock_enabled_flag mtl_system_items_b.stock_enabled_flag%Type
569: , bom_enabled_flag mtl_system_items_b.bom_enabled_flag%Type
570: , build_in_wip_flag mtl_system_items_b.build_in_wip_flag%Type
571: , invoice_enabled_flag mtl_system_items_b.invoice_enabled_flag%Type

Line 568: , stock_enabled_flag mtl_system_items_b.stock_enabled_flag%Type

564: , purchasing_enabled_flag mtl_system_items_b.purchasing_enabled_flag%Type
565: , customer_order_enabled_flag mtl_system_items_b.customer_order_enabled_flag%Type
566: , internal_order_enabled_flag mtl_system_items_b.internal_order_enabled_flag%Type
567: , mtl_transactions_enabled_flag mtl_system_items_b.mtl_transactions_enabled_flag%Type
568: , stock_enabled_flag mtl_system_items_b.stock_enabled_flag%Type
569: , bom_enabled_flag mtl_system_items_b.bom_enabled_flag%Type
570: , build_in_wip_flag mtl_system_items_b.build_in_wip_flag%Type
571: , invoice_enabled_flag mtl_system_items_b.invoice_enabled_flag%Type
572: , source_organization_id mtl_system_items_b.source_organization_id%Type --myerrams, Bug: 5964347

Line 569: , bom_enabled_flag mtl_system_items_b.bom_enabled_flag%Type

565: , customer_order_enabled_flag mtl_system_items_b.customer_order_enabled_flag%Type
566: , internal_order_enabled_flag mtl_system_items_b.internal_order_enabled_flag%Type
567: , mtl_transactions_enabled_flag mtl_system_items_b.mtl_transactions_enabled_flag%Type
568: , stock_enabled_flag mtl_system_items_b.stock_enabled_flag%Type
569: , bom_enabled_flag mtl_system_items_b.bom_enabled_flag%Type
570: , build_in_wip_flag mtl_system_items_b.build_in_wip_flag%Type
571: , invoice_enabled_flag mtl_system_items_b.invoice_enabled_flag%Type
572: , source_organization_id mtl_system_items_b.source_organization_id%Type --myerrams, Bug: 5964347
573: , source_subinventory mtl_system_items_b.source_subinventory%Type --myerrams, Bug: 5964347

Line 570: , build_in_wip_flag mtl_system_items_b.build_in_wip_flag%Type

566: , internal_order_enabled_flag mtl_system_items_b.internal_order_enabled_flag%Type
567: , mtl_transactions_enabled_flag mtl_system_items_b.mtl_transactions_enabled_flag%Type
568: , stock_enabled_flag mtl_system_items_b.stock_enabled_flag%Type
569: , bom_enabled_flag mtl_system_items_b.bom_enabled_flag%Type
570: , build_in_wip_flag mtl_system_items_b.build_in_wip_flag%Type
571: , invoice_enabled_flag mtl_system_items_b.invoice_enabled_flag%Type
572: , source_organization_id mtl_system_items_b.source_organization_id%Type --myerrams, Bug: 5964347
573: , source_subinventory mtl_system_items_b.source_subinventory%Type --myerrams, Bug: 5964347
574: );

Line 571: , invoice_enabled_flag mtl_system_items_b.invoice_enabled_flag%Type

567: , mtl_transactions_enabled_flag mtl_system_items_b.mtl_transactions_enabled_flag%Type
568: , stock_enabled_flag mtl_system_items_b.stock_enabled_flag%Type
569: , bom_enabled_flag mtl_system_items_b.bom_enabled_flag%Type
570: , build_in_wip_flag mtl_system_items_b.build_in_wip_flag%Type
571: , invoice_enabled_flag mtl_system_items_b.invoice_enabled_flag%Type
572: , source_organization_id mtl_system_items_b.source_organization_id%Type --myerrams, Bug: 5964347
573: , source_subinventory mtl_system_items_b.source_subinventory%Type --myerrams, Bug: 5964347
574: );
575:

Line 572: , source_organization_id mtl_system_items_b.source_organization_id%Type --myerrams, Bug: 5964347

568: , stock_enabled_flag mtl_system_items_b.stock_enabled_flag%Type
569: , bom_enabled_flag mtl_system_items_b.bom_enabled_flag%Type
570: , build_in_wip_flag mtl_system_items_b.build_in_wip_flag%Type
571: , invoice_enabled_flag mtl_system_items_b.invoice_enabled_flag%Type
572: , source_organization_id mtl_system_items_b.source_organization_id%Type --myerrams, Bug: 5964347
573: , source_subinventory mtl_system_items_b.source_subinventory%Type --myerrams, Bug: 5964347
574: );
575:
576: -- Define a table of above record type

Line 573: , source_subinventory mtl_system_items_b.source_subinventory%Type --myerrams, Bug: 5964347

569: , bom_enabled_flag mtl_system_items_b.bom_enabled_flag%Type
570: , build_in_wip_flag mtl_system_items_b.build_in_wip_flag%Type
571: , invoice_enabled_flag mtl_system_items_b.invoice_enabled_flag%Type
572: , source_organization_id mtl_system_items_b.source_organization_id%Type --myerrams, Bug: 5964347
573: , source_subinventory mtl_system_items_b.source_subinventory%Type --myerrams, Bug: 5964347
574: );
575:
576: -- Define a table of above record type
577: TYPE mtl_system_items_tbl IS TABLE OF mtl_system_items_rec

Line 582: -- Cursor to retrieve all the inventory items from the mtl_system_items_b

578: INDEX BY BINARY_INTEGER;
579: l_mtl_system_items_tbl mtl_system_items_tbl;
580:
581:
582: -- Cursor to retrieve all the inventory items from the mtl_system_items_b
583: -- for the source organization id.
584: CURSOR c_item_cursor
585: IS
586: SELECT inventory_item_id

Line 597: FROM mtl_system_items_b

593: , build_in_wip_flag
594: , invoice_enabled_flag
595: , source_organization_id --myerrams, Bug: 5964347
596: , source_subinventory --myerrams, Bug: 5964347
597: FROM mtl_system_items_b
598: WHERE organization_id = p_source_org_id
599: AND ((base_item_id is null and p_copy_base_models = 'Y') or (base_item_id is not null and p_copy_base_models = 'N'))
600: AND eng_item_flag = p_copy_eng_items;
601:

Line 637: FROM mtl_system_items_b

633: -- Find number of items from source organizations based on input
634: -- parameters p_copy_base_models and p_copy_eng_items
635: SELECT COUNT(*)
636: INTO l_count
637: FROM mtl_system_items_b
638: WHERE organization_id = p_source_org_id
639: AND ((base_item_id is null and p_copy_base_models = 'Y') or (base_item_id is not null and p_copy_base_models = 'N'))
640: AND eng_item_flag = p_copy_eng_items;
641: