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 163: TYPE typeInventoryItemId IS TABLE OF mtl_system_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

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

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

503: localString VARCHAR2(2000);
504: bomQuantity NUMBER;
505: nodeQuantity NUMBER;
506:
507: lastConcatSegments mtl_system_items_vl.concatenated_segments%TYPE := NULL;
508: itemConcatSegments mtl_system_items_vl.concatenated_segments%TYPE;
509: itemInventoryId mtl_system_items.inventory_item_id%TYPE;
510: itemCatalogGroupId mtl_system_items.item_catalog_group_id%TYPE;
511:

Line 508: itemConcatSegments mtl_system_items_vl.concatenated_segments%TYPE;

504: bomQuantity NUMBER;
505: nodeQuantity NUMBER;
506:
507: lastConcatSegments mtl_system_items_vl.concatenated_segments%TYPE := NULL;
508: itemConcatSegments mtl_system_items_vl.concatenated_segments%TYPE;
509: itemInventoryId mtl_system_items.inventory_item_id%TYPE;
510: itemCatalogGroupId mtl_system_items.item_catalog_group_id%TYPE;
511:
512: billSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;

Line 509: itemInventoryId mtl_system_items.inventory_item_id%TYPE;

505: nodeQuantity NUMBER;
506:
507: lastConcatSegments mtl_system_items_vl.concatenated_segments%TYPE := NULL;
508: itemConcatSegments mtl_system_items_vl.concatenated_segments%TYPE;
509: itemInventoryId mtl_system_items.inventory_item_id%TYPE;
510: itemCatalogGroupId mtl_system_items.item_catalog_group_id%TYPE;
511:
512: billSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
513: billCommonSequenceId bom_bill_of_materials.common_bill_sequence_id%TYPE;

Line 510: itemCatalogGroupId mtl_system_items.item_catalog_group_id%TYPE;

506:
507: lastConcatSegments mtl_system_items_vl.concatenated_segments%TYPE := NULL;
508: itemConcatSegments mtl_system_items_vl.concatenated_segments%TYPE;
509: itemInventoryId mtl_system_items.inventory_item_id%TYPE;
510: itemCatalogGroupId mtl_system_items.item_catalog_group_id%TYPE;
511:
512: billSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
513: billCommonSequenceId bom_bill_of_materials.common_bill_sequence_id%TYPE;
514: useSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;

Line 624: ' FROM mtl_system_items_b'|| targetLinkName ||

620: IF c_prop.src_application_id = APC_APPL_ID THEN
621: --This is an APC attribute
622: EXECUTE IMMEDIATE
623: 'SELECT distinct item_catalog_group_id '||
624: ' FROM mtl_system_items_b'|| targetLinkName ||
625: ' WHERE organization_id = :1 '||
626: ' AND inventory_item_id = :2 '||
627: ' AND item_catalog_group_id IS NOT NULL'
628: INTO l_item_catalog_group_id

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

745: BEGIN
746:
747: EXECUTE IMMEDIATE
748: 'SELECT b.bill_sequence_id, b.common_bill_sequence_id, i.inventory_item_id, i.item_catalog_group_id' ||
749: ' FROM bom_bill_of_materials' || targetLinkName || ' b, mtl_system_items_vl' || targetLinkName || ' i' ||
750: ' WHERE i.concatenated_segments = :1' ||
751: ' AND i.organization_id = :2' ||
752: ' AND b.assembly_item_id = i.inventory_item_id' ||
753: ' AND b.organization_id = i.organization_id' ||

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

804: OPEN getBillChildren FOR
805: 'SELECT i.inventory_item_id, i.concatenated_segments, b.effectivity_date, b.disable_date, b.component_quantity,' ||
806: ' b.component_sequence_id, b.high_quantity, b.low_quantity, b.mutually_exclusive_options,' ||
807: ' b.bom_item_type, b.optional, i.item_catalog_group_id' ||
808: ' FROM mtl_system_items_vl' || targetLinkName || ' i, bom_inventory_components' || targetLinkName || ' b' ||
809: ' WHERE b.bill_sequence_id = :1' ||
810: ' AND b.implementation_date IS NOT NULL' ||
811: ' AND i.organization_id = :2' ||
812: ' AND (b.optional = :3 OR b.bom_item_type <= :4)' ||