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 142: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;

138: SELECT UPPER(VALUE) FROM CZ_DB_SETTINGS
139: WHERE UPPER(SECTION_NAME) = v_section_name
140: AND UPPER(SETTING_ID) = v_settings_id;
141:
142: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;
143: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
144: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
145: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;

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

139: WHERE UPPER(SECTION_NAME) = v_section_name
140: AND UPPER(SETTING_ID) = v_settings_id;
141:
142: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;
143: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
144: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
145: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
147: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;

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

140: AND UPPER(SETTING_ID) = v_settings_id;
141:
142: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;
143: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
144: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
145: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
147: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
148: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;

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

141:
142: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;
143: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
144: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
145: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
147: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
148: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
149: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;

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

142: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;
143: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
144: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
145: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
147: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
148: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
149: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
150: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;

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

143: TYPE tBomItemType IS TABLE OF cz_exv_items.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
144: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
145: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
147: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
148: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
149: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
150: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
151: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;

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

144: TYPE tOrganizationId IS TABLE OF cz_exv_items.organization_id%TYPE INDEX BY BINARY_INTEGER;
145: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
147: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
148: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
149: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
150: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
151: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
152: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;

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

145: TYPE tInventoryItemId IS TABLE OF cz_exv_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
147: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
148: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
149: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
150: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
151: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
152: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
153: TYPE tPrimaryUomCode IS TABLE OF cz_exv_items.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;

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

146: TYPE tSegment1 IS TABLE OF cz_exv_items.segment1%TYPE INDEX BY BINARY_INTEGER;
147: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
148: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
149: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
150: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
151: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
152: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
153: TYPE tPrimaryUomCode IS TABLE OF cz_exv_items.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
154:

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

147: TYPE tConcatenatedSegments IS TABLE OF cz_exv_items.concatenated_segments%TYPE INDEX BY BINARY_INTEGER;
148: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
149: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
150: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
151: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
152: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
153: TYPE tPrimaryUomCode IS TABLE OF cz_exv_items.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
154:
155: TYPE tOrigSysRef IS TABLE OF cz_imp_item_master.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

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

148: TYPE tFixedLeadTime IS TABLE OF cz_exv_items.fixed_lead_time%TYPE INDEX BY BINARY_INTEGER;
149: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
150: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
151: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
152: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
153: TYPE tPrimaryUomCode IS TABLE OF cz_exv_items.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
154:
155: TYPE tOrigSysRef IS TABLE OF cz_imp_item_master.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
156: TYPE tRefPartNbr IS TABLE OF cz_imp_item_master.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;

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

149: TYPE tItemStatusCode IS TABLE OF cz_exv_items.inventory_item_status_code%TYPE INDEX BY BINARY_INTEGER;
150: TYPE tCatalogId IS TABLE OF cz_exv_items.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
151: TYPE tIndivisibleFlag IS TABLE OF cz_exv_items.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
152: TYPE tCustomerOrderFlag IS TABLE OF cz_exv_items.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
153: TYPE tPrimaryUomCode IS TABLE OF cz_exv_items.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
154:
155: TYPE tOrigSysRef IS TABLE OF cz_imp_item_master.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
156: TYPE tRefPartNbr IS TABLE OF cz_imp_item_master.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;
157: TYPE tDescText IS TABLE OF cz_imp_item_master.desc_text%TYPE INDEX BY BINARY_INTEGER;

Line 222: FROM CZ_EXV_ITEMS

218: InventoryItemId, OrganizationId, Segment1, ConcatenatedSegments, ItemDesc,
219: FixedLeadTime, BomItemType, CustomerOrderFlag,
220: ItemStatusCode, PrimaryUomCode, IndivisibleFlag, CatalogId,
221: SrcApplicationId
222: FROM CZ_EXV_ITEMS
223: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID
224: AND EXPLOSION_TYPE=sExpl_type;
225:
226: if (CZ_IMP_ALL.get_time) then

Line 2476: 'AND EXISTS (SELECT NULL FROM CZ_EXV_ITEMS '||

2472: ---Bug Fix - 8519380
2473: l_sql := 'SELECT apcpropvals.* FROM CZ_EXV_ITEM_APC_PROP_VALUES apcpropvals,'||
2474: 'CZ_IMP_TMP_ITEMCAT itemtypes '||
2475: 'WHERE apcpropvals.item_catalog_group_id = itemtypes.item_catalog_group_id '||
2476: 'AND EXISTS (SELECT NULL FROM CZ_EXV_ITEMS '||
2477: 'WHERE inventory_item_id = apcpropvals.inventory_item_id '||
2478: ' AND organization_id = '|| p_org_id ||
2479: ' AND top_item_id = '||p_top_item_id||
2480: ' AND explosion_type = '''||p_expl_type||''')'||