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_ITEM_MASTER

Line 29: TYPE tCatalogGroupId IS TABLE OF cz_exv_item_master.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;

25:
26: g_ItemCatalogTable SYSTEM.CZ_ITEM_CATALOG_TBL := SYSTEM.CZ_ITEM_CATALOG_TBL(SYSTEM.CZ_ITEM_CATALOG_REC(NULL));
27: g_CONFIG_ENGINE_TYPE VARCHAR2(10);
28:
29: TYPE tCatalogGroupId IS TABLE OF cz_exv_item_master.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
30: TYPE tInventoryItemId IS TABLE OF cz_exv_item_master.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
31: TYPE tInt IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
32:
33: itemCatalogGroupId tCatalogGroupId;

Line 30: TYPE tInventoryItemId IS TABLE OF cz_exv_item_master.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

26: g_ItemCatalogTable SYSTEM.CZ_ITEM_CATALOG_TBL := SYSTEM.CZ_ITEM_CATALOG_TBL(SYSTEM.CZ_ITEM_CATALOG_REC(NULL));
27: g_CONFIG_ENGINE_TYPE VARCHAR2(10);
28:
29: TYPE tCatalogGroupId IS TABLE OF cz_exv_item_master.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
30: TYPE tInventoryItemId IS TABLE OF cz_exv_item_master.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
31: TYPE tInt IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
32:
33: itemCatalogGroupId tCatalogGroupId;
34: repCatalogGroupId tCatalogGroupId;

Line 469: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;

465: TYPE tIntegerArray IS TABLE OF PLS_INTEGER INDEX BY BINARY_INTEGER;
466: TYPE tStringArray IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
467: TYPE tNumberArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
468:
469: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
470: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
471: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
472: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
473: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;

Line 470: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;

466: TYPE tStringArray IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
467: TYPE tNumberArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
468:
469: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
470: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
471: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
472: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
473: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
474: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

Line 471: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;

467: TYPE tNumberArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
468:
469: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
470: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
471: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
472: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
473: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
474: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
475: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;

Line 472: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;

468:
469: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
470: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
471: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
472: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
473: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
474: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
475: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
476: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;

Line 473: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;

469: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
470: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
471: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
472: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
473: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
474: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
475: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
476: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
477: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;

Line 474: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

470: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
471: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
472: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
473: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
474: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
475: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
476: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
477: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
478: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;

Line 475: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;

471: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
472: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
473: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
474: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
475: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
476: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
477: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
478: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
479: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;

Line 476: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;

472: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
473: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
474: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
475: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
476: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
477: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
478: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
479: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
480: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;

Line 477: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;

473: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
474: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
475: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
476: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
477: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
478: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
479: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
480: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
481: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;

Line 478: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;

474: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
475: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
476: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
477: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
478: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
479: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
480: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
481: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
482: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;

Line 479: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;

475: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
476: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
477: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
478: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
479: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
480: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
481: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
482: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
483: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;

Line 480: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;

476: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
477: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
478: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
479: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
480: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
481: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
482: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
483: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
484: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;

Line 481: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;

477: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
478: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
479: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
480: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
481: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
482: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
483: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
484: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
485: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;

Line 482: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;

478: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
479: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
480: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
481: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
482: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
483: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
484: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
485: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
486: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;

Line 483: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;

479: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
480: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
481: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
482: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
483: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
484: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
485: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
486: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
487: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;

Line 484: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;

480: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
481: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
482: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
483: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
484: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
485: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
486: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
487: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
488: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;

Line 485: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;

481: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
482: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
483: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
484: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
485: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
486: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
487: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
488: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
489: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;

Line 486: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;

482: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
483: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
484: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
485: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
486: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
487: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
488: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
489: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
490: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;

Line 487: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;

483: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
484: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
485: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
486: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
487: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
488: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
489: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
490: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
491: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;

Line 488: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;

484: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
485: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
486: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
487: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
488: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
489: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
490: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
491: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
492: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;

Line 489: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;

485: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
486: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
487: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
488: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
489: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
490: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
491: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
492: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
493: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;

Line 490: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;

486: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
487: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
488: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
489: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
490: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
491: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
492: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
493: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
494: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;

Line 491: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;

487: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
488: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
489: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
490: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
491: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
492: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
493: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
494: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;
495: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;

Line 492: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;

488: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
489: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
490: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
491: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
492: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
493: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
494: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;
495: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
496:

Line 493: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;

489: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
490: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
491: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
492: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
493: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
494: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;
495: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
496:
497: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;

Line 494: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;

490: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
491: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
492: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
493: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
494: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;
495: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
496:
497: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
498: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

Line 495: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;

491: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
492: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
493: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
494: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;
495: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
496:
497: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
498: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
499: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

Line 534: TYPE tShippableItemFlag IS TABLE OF cz_exv_item_master.shippable_item_flag%TYPE

530: TYPE tIBLinkItemFlag IS TABLE OF cz_imp_ps_nodes.ib_link_item_flag%TYPE INDEX BY BINARY_INTEGER;
531:
532: -- changes for TSO --
533:
534: TYPE tShippableItemFlag IS TABLE OF cz_exv_item_master.shippable_item_flag%TYPE
535: INDEX BY BINARY_INTEGER;
536: TYPE tTransEnabledFlag IS TABLE OF cz_exv_item_master.mtl_transactions_enabled_flag%TYPE
537: INDEX BY BINARY_INTEGER;
538: TYPE tReplenishToOrderFlag IS TABLE OF cz_exv_item_master.replenish_to_order_flag%TYPE

Line 536: TYPE tTransEnabledFlag IS TABLE OF cz_exv_item_master.mtl_transactions_enabled_flag%TYPE

532: -- changes for TSO --
533:
534: TYPE tShippableItemFlag IS TABLE OF cz_exv_item_master.shippable_item_flag%TYPE
535: INDEX BY BINARY_INTEGER;
536: TYPE tTransEnabledFlag IS TABLE OF cz_exv_item_master.mtl_transactions_enabled_flag%TYPE
537: INDEX BY BINARY_INTEGER;
538: TYPE tReplenishToOrderFlag IS TABLE OF cz_exv_item_master.replenish_to_order_flag%TYPE
539: INDEX BY BINARY_INTEGER;
540: TYPE tSerialNumberControlCode IS TABLE OF cz_exv_item_master.serial_number_control_code%TYPE

Line 538: TYPE tReplenishToOrderFlag IS TABLE OF cz_exv_item_master.replenish_to_order_flag%TYPE

534: TYPE tShippableItemFlag IS TABLE OF cz_exv_item_master.shippable_item_flag%TYPE
535: INDEX BY BINARY_INTEGER;
536: TYPE tTransEnabledFlag IS TABLE OF cz_exv_item_master.mtl_transactions_enabled_flag%TYPE
537: INDEX BY BINARY_INTEGER;
538: TYPE tReplenishToOrderFlag IS TABLE OF cz_exv_item_master.replenish_to_order_flag%TYPE
539: INDEX BY BINARY_INTEGER;
540: TYPE tSerialNumberControlCode IS TABLE OF cz_exv_item_master.serial_number_control_code%TYPE
541: INDEX BY BINARY_INTEGER;
542:

Line 540: TYPE tSerialNumberControlCode IS TABLE OF cz_exv_item_master.serial_number_control_code%TYPE

536: TYPE tTransEnabledFlag IS TABLE OF cz_exv_item_master.mtl_transactions_enabled_flag%TYPE
537: INDEX BY BINARY_INTEGER;
538: TYPE tReplenishToOrderFlag IS TABLE OF cz_exv_item_master.replenish_to_order_flag%TYPE
539: INDEX BY BINARY_INTEGER;
540: TYPE tSerialNumberControlCode IS TABLE OF cz_exv_item_master.serial_number_control_code%TYPE
541: INDEX BY BINARY_INTEGER;
542:
543: TYPE tPSShippableItemFlag IS TABLE OF cz_imp_ps_nodes.shippable_item_flag%TYPE
544: INDEX BY BINARY_INTEGER;

Line 707: FROM cz_exv_item_master

703: DECODE(SHIPPABLE_ITEM_FLAG,'Y','1','N','0','0'),
704: DECODE(MTL_TRANSACTIONS_ENABLED_FLAG,'Y','1','N','0','0'),
705: DECODE(REPLENISH_TO_ORDER_FLAG,'Y','1','N','0','0'),
706: SERIAL_NUMBER_CONTROL_CODE
707: FROM cz_exv_item_master
708: WHERE organization_id = nOrg_ID
709: AND top_item_id = nTop_ID
710: AND explosion_type = sExpl_type
711: AND language = inLang

Line 1871: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;

1867: nModelId IN NUMBER)
1868: IS
1869: xERROR BOOLEAN:=FALSE;
1870:
1871: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
1872: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;

Line 1872: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;

1868: IS
1869: xERROR BOOLEAN:=FALSE;
1870:
1871: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
1872: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;

Line 1873: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;

1869: xERROR BOOLEAN:=FALSE;
1870:
1871: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
1872: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1877:

Line 1874: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;

1870:
1871: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
1872: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1877:
1878: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

Line 1875: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;

1871: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
1872: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1877:
1878: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;

Line 1876: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;

1872: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1877:
1878: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;

Line 1925: FROM CZ_EXV_ITEM_MASTER WHERE bom_item_type = cz_imp_ps_node.cnModel

1921: ORGANIZATION_ID, COMPONENT_ITEM_ID, EXPLOSION_TYPE,
1922: DESCRIPTION, PLAN_LEVEL, MODEL_TYPE, CONFIG_MODEL_TYPE
1923: BULK COLLECT INTO
1924: OrganizationId, ComponentItemId, ExplosionType, Description, PlanLevel, ModelType, ConfigModelType
1925: FROM CZ_EXV_ITEM_MASTER WHERE bom_item_type = cz_imp_ps_node.cnModel
1926: AND ORGANIZATION_ID=nOrg_ID
1927: AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type
1928: AND language = l_lang;
1929:

Line 3250: SELECT component_item_id, component_code FROM cz_exv_item_master

3246: inGenStatistics IN PLS_INTEGER)
3247: RETURN NUMBER IS
3248:
3249: CURSOR c_expl (inLang VARCHAR2) IS
3250: SELECT component_item_id, component_code FROM cz_exv_item_master
3251: WHERE top_item_id = inTopId
3252: AND organization_id = inOrgId
3253: AND explosion_type = inExplType
3254: AND bom_item_type = 1

Line 4112: FROM cz_exv_item_master

4108:
4109: BEGIN
4110: SELECT item_catalog_group_id, inventory_item_id
4111: BULK COLLECT INTO repCatalogGroupId, repItemId
4112: FROM cz_exv_item_master
4113: WHERE organization_id = nOrg_ID
4114: AND top_item_id = nTop_ID
4115: AND explosion_type = sExpl_type
4116: AND item_catalog_group_id IS NOT NULL