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_IMP_SINGLE dependencies on CZ_EXV_ITEMS

Line 120: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;

116: SELECT UPPER(VALUE) FROM CZ_DB_SETTINGS
117: WHERE UPPER(SECTION_NAME) = v_section_name
118: AND UPPER(SETTING_ID) = v_settings_id;
119:
120: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;
121: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
123: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
124: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;

Line 121: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;

117: WHERE UPPER(SECTION_NAME) = v_section_name
118: AND UPPER(SETTING_ID) = v_settings_id;
119:
120: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;
121: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
123: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
124: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
125: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;

Line 122: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;

118: AND UPPER(SETTING_ID) = v_settings_id;
119:
120: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;
121: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
123: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
124: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
125: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
126: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;

Line 123: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

119:
120: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;
121: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
123: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
124: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
125: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
126: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
127: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;

Line 124: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;

120: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;
121: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
123: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
124: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
125: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
126: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
127: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
128: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;

Line 125: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;

121: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
122: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
123: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
124: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
125: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
126: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
127: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
128: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
129: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;

Line 126: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;

122: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
123: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
124: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
125: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
126: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
127: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
128: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
129: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
130: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;

Line 127: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;

123: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
124: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
125: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
126: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
127: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
128: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
129: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
130: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
131: TYPE tPrimaryUomCode IS TABLE OF cz_exv_items.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;

Line 128: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;

124: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
125: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
126: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
127: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
128: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
129: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
130: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
131: TYPE tPrimaryUomCode IS TABLE OF cz_exv_items.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
132:

Line 129: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;

125: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
126: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
127: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
128: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
129: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
130: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
131: TYPE tPrimaryUomCode IS TABLE OF cz_exv_items.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
132:
133: TYPE tOrigSysRef IS TABLE OF cz_imp_item_master.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

Line 130: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;

126: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
127: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
128: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
129: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
130: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
131: TYPE tPrimaryUomCode IS TABLE OF cz_exv_items.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
132:
133: TYPE tOrigSysRef IS TABLE OF cz_imp_item_master.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
134: TYPE tRefPartNbr IS TABLE OF cz_imp_item_master.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;

Line 131: TYPE tPrimaryUomCode IS TABLE OF cz_exv_items.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;

127: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
128: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
129: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
130: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
131: TYPE tPrimaryUomCode IS TABLE OF cz_exv_items.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
132:
133: TYPE tOrigSysRef IS TABLE OF cz_imp_item_master.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
134: TYPE tRefPartNbr IS TABLE OF cz_imp_item_master.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;
135: TYPE tDescText IS TABLE OF cz_imp_item_master.desc_text%TYPE INDEX BY BINARY_INTEGER;

Line 200: FROM CZ_EXV_ITEMS

196: InventoryItemId, OrganizationId, Segment1, ConcatenatedSegments, ItemDesc,
197: FixedLeadTime, BomItemType, CustomerOrderFlag,
198: ItemStatusCode, PrimaryUomCode, IndivisibleFlag, CatalogId,
199: SrcApplicationId
200: FROM CZ_EXV_ITEMS
201: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID
202: AND EXPLOSION_TYPE=sExpl_type;
203:
204: if (CZ_IMP_ALL.get_time) then