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.CZ_BOM_SYNCH dependencies on MTL_SYSTEM_ITEMS

Line 167: TYPE typeInventoryItemId IS TABLE OF mtl_system_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

163: TYPE typePubOrganizationId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY BINARY_INTEGER;
164: TYPE typePubTopItemId IS TABLE OF cz_model_publications.top_item_id%TYPE INDEX BY BINARY_INTEGER;
165: TYPE typePubProductKey IS TABLE OF cz_model_publications.product_key%TYPE INDEX BY BINARY_INTEGER;
166:
167: TYPE typeInventoryItemId IS TABLE OF mtl_system_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
168: TYPE typePropertyId IS TABLE OF CZ_ITEM_TYPE_PROPERTIES.PROPERTY_ID%TYPE INDEX BY BINARY_INTEGER;
169:
170: thisVersionString user_source.text%TYPE;
171:

Line 511: lastConcatSegments mtl_system_items_vl.concatenated_segments%TYPE := NULL;

507: localString VARCHAR2(2000);
508: bomQuantity NUMBER;
509: nodeQuantity NUMBER;
510:
511: lastConcatSegments mtl_system_items_vl.concatenated_segments%TYPE := NULL;
512: itemConcatSegments mtl_system_items_vl.concatenated_segments%TYPE;
513: itemInventoryId mtl_system_items.inventory_item_id%TYPE;
514: itemCatalogGroupId mtl_system_items.item_catalog_group_id%TYPE;
515:

Line 512: itemConcatSegments mtl_system_items_vl.concatenated_segments%TYPE;

508: bomQuantity NUMBER;
509: nodeQuantity NUMBER;
510:
511: lastConcatSegments mtl_system_items_vl.concatenated_segments%TYPE := NULL;
512: itemConcatSegments mtl_system_items_vl.concatenated_segments%TYPE;
513: itemInventoryId mtl_system_items.inventory_item_id%TYPE;
514: itemCatalogGroupId mtl_system_items.item_catalog_group_id%TYPE;
515:
516: billSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;

Line 513: itemInventoryId mtl_system_items.inventory_item_id%TYPE;

509: nodeQuantity NUMBER;
510:
511: lastConcatSegments mtl_system_items_vl.concatenated_segments%TYPE := NULL;
512: itemConcatSegments mtl_system_items_vl.concatenated_segments%TYPE;
513: itemInventoryId mtl_system_items.inventory_item_id%TYPE;
514: itemCatalogGroupId mtl_system_items.item_catalog_group_id%TYPE;
515:
516: billSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
517: billCommonSequenceId bom_bill_of_materials.common_bill_sequence_id%TYPE;

Line 514: itemCatalogGroupId mtl_system_items.item_catalog_group_id%TYPE;

510:
511: lastConcatSegments mtl_system_items_vl.concatenated_segments%TYPE := NULL;
512: itemConcatSegments mtl_system_items_vl.concatenated_segments%TYPE;
513: itemInventoryId mtl_system_items.inventory_item_id%TYPE;
514: itemCatalogGroupId mtl_system_items.item_catalog_group_id%TYPE;
515:
516: billSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
517: billCommonSequenceId bom_bill_of_materials.common_bill_sequence_id%TYPE;
518: useSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;

Line 630: ' FROM mtl_system_items_b'|| targetLinkName ||

626: IF c_prop.src_application_id = APC_APPL_ID THEN
627: --This is an APC attribute
628: EXECUTE IMMEDIATE
629: 'SELECT distinct item_catalog_group_id '||
630: ' FROM mtl_system_items_b'|| targetLinkName ||
631: ' WHERE organization_id = :1 '||
632: ' AND inventory_item_id = :2 '||
633: ' AND item_catalog_group_id IS NOT NULL'
634: INTO l_item_catalog_group_id

Line 760: ' FROM bom_bill_of_materials' || targetLinkName || ' b, mtl_system_items_vl' || targetLinkName || ' i' ||

756: BEGIN
757:
758: EXECUTE IMMEDIATE
759: 'SELECT b.bill_sequence_id, b.common_bill_sequence_id, i.inventory_item_id, i.item_catalog_group_id' ||
760: ' FROM bom_bill_of_materials' || targetLinkName || ' b, mtl_system_items_vl' || targetLinkName || ' i' ||
761: ' WHERE i.concatenated_segments = :1' ||
762: ' AND i.organization_id = :2' ||
763: ' AND b.assembly_item_id = i.inventory_item_id' ||
764: ' AND b.organization_id = i.organization_id' ||

Line 819: ' FROM mtl_system_items_vl' || targetLinkName || ' i, bom_inventory_components' || targetLinkName || ' b' ||

815: OPEN getBillChildren FOR
816: 'SELECT i.inventory_item_id, i.concatenated_segments, b.effectivity_date, b.disable_date, b.component_quantity,' ||
817: ' b.component_sequence_id, b.high_quantity, b.low_quantity, b.mutually_exclusive_options,' ||
818: ' b.bom_item_type, b.optional, i.item_catalog_group_id' ||
819: ' FROM mtl_system_items_vl' || targetLinkName || ' i, bom_inventory_components' || targetLinkName || ' b' ||
820: ' WHERE b.bill_sequence_id = :1' ||
821: ' AND b.implementation_date IS NOT NULL' ||
822: ' AND i.organization_id = :2' ||
823: ' AND (b.optional = :3 OR b.bom_item_type <= :4)' ||