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 445: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;

441: TYPE tIntegerArray IS TABLE OF PLS_INTEGER INDEX BY BINARY_INTEGER;
442: TYPE tStringArray IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
443: TYPE tNumberArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
444:
445: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
446: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
447: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
448: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
449: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;

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

442: TYPE tStringArray IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
443: TYPE tNumberArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
444:
445: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
446: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
447: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
448: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
449: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
450: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

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

443: TYPE tNumberArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
444:
445: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
446: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
447: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
448: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
449: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
450: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
451: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;

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

444:
445: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
446: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
447: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
448: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
449: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
450: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
451: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
452: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;

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

445: TYPE tComponentSequenceId IS TABLE OF cz_exv_item_master.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
446: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
447: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
448: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
449: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
450: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
451: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
452: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
453: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;

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

446: TYPE tComponentCode IS TABLE OF cz_exv_item_master.component_code%TYPE INDEX BY BINARY_INTEGER;
447: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
448: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
449: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
450: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
451: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
452: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
453: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
454: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;

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

447: TYPE tCreationDate IS TABLE OF cz_exv_item_master.creation_date%TYPE INDEX BY BINARY_INTEGER;
448: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
449: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
450: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
451: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
452: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
453: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
454: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
455: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;

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

448: TYPE tCreatedBy IS TABLE OF cz_exv_item_master.created_by%TYPE INDEX BY BINARY_INTEGER;
449: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
450: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
451: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
452: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
453: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
454: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
455: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
456: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;

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

449: TYPE tLastUpdateDate IS TABLE OF cz_exv_item_master.last_update_date%TYPE INDEX BY BINARY_INTEGER;
450: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
451: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
452: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
453: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
454: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
455: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
456: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
457: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;

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

450: TYPE tLastUpdatedBy IS TABLE OF cz_exv_item_master.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
451: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
452: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
453: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
454: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
455: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
456: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
457: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
458: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;

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

451: TYPE tEffectivityDate IS TABLE OF cz_exv_item_master.effectivity_date%TYPE INDEX BY BINARY_INTEGER;
452: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
453: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
454: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
455: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
456: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
457: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
458: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
459: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;

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

452: TYPE tDisableDate IS TABLE OF cz_exv_item_master.disable_date%TYPE INDEX BY BINARY_INTEGER;
453: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
454: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
455: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
456: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
457: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
458: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
459: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
460: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;

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

453: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
454: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
455: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
456: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
457: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
458: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
459: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
460: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
461: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;

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

454: TYPE tLowQuantity IS TABLE OF cz_exv_item_master.low_quantity%TYPE INDEX BY BINARY_INTEGER;
455: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
456: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
457: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
458: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
459: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
460: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
461: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
462: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;

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

455: TYPE tHighQuantity IS TABLE OF cz_exv_item_master.high_quantity%TYPE INDEX BY BINARY_INTEGER;
456: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
457: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
458: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
459: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
460: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
461: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
462: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
463: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;

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

456: TYPE tSortOrder IS TABLE OF cz_exv_item_master.sort_order%TYPE INDEX BY BINARY_INTEGER;
457: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
458: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
459: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
460: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
461: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
462: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
463: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
464: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;

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

457: TYPE tBomItemType IS TABLE OF cz_exv_item_master.bom_item_type%TYPE INDEX BY BINARY_INTEGER;
458: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
459: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
460: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
461: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
462: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
463: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
464: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
465: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;

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

458: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
459: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
460: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
461: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
462: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
463: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
464: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
465: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
466: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;

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

459: TYPE tMutuallyExclusiveOptions IS TABLE OF cz_exv_item_master.mutually_exclusive_options%TYPE INDEX BY BINARY_INTEGER;
460: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
461: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
462: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
463: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
464: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
465: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
466: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
467: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;

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

460: TYPE tPickComponentsFlag IS TABLE OF cz_exv_item_master.pick_components_flag%TYPE INDEX BY BINARY_INTEGER;
461: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
462: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
463: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
464: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
465: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
466: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
467: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
468: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;

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

461: TYPE tComponentQuantity IS TABLE OF cz_exv_item_master.component_quantity%TYPE INDEX BY BINARY_INTEGER;
462: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
463: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
464: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
465: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
466: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
467: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
468: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
469: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;

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

462: TYPE tOptional IS TABLE OF cz_exv_item_master.optional%TYPE INDEX BY BINARY_INTEGER;
463: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
464: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
465: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
466: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
467: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
468: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
469: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
470: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;

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

463: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
464: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
465: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
466: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
467: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
468: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
469: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
470: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;
471: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;

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

464: TYPE tTopItemId IS TABLE OF cz_exv_item_master.top_item_id%TYPE INDEX BY BINARY_INTEGER;
465: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
466: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
467: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
468: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
469: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
470: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;
471: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
472:

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

465: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
466: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
467: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
468: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
469: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
470: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;
471: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
472:
473: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;

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

466: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
467: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
468: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
469: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
470: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;
471: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
472:
473: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
474: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

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

467: TYPE tIndivisibleFlag IS TABLE OF cz_exv_item_master.indivisible_flag%TYPE INDEX BY BINARY_INTEGER;
468: TYPE tCustomerOrderEnabledFlag IS TABLE OF cz_exv_item_master.customer_order_enabled_flag%TYPE INDEX BY BINARY_INTEGER;
469: TYPE tPrimaryUomCode IS TABLE OF cz_exv_item_master.primary_uom_code%TYPE INDEX BY BINARY_INTEGER;
470: TYPE tConfigModelType IS TABLE OF cz_exv_item_master.config_model_type%TYPE INDEX BY BINARY_INTEGER;
471: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
472:
473: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
474: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
475: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

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

506: TYPE tIBLinkItemFlag IS TABLE OF cz_imp_ps_nodes.ib_link_item_flag%TYPE INDEX BY BINARY_INTEGER;
507:
508: -- changes for TSO --
509:
510: TYPE tShippableItemFlag IS TABLE OF cz_exv_item_master.shippable_item_flag%TYPE
511: INDEX BY BINARY_INTEGER;
512: TYPE tTransEnabledFlag IS TABLE OF cz_exv_item_master.mtl_transactions_enabled_flag%TYPE
513: INDEX BY BINARY_INTEGER;
514: TYPE tReplenishToOrderFlag IS TABLE OF cz_exv_item_master.replenish_to_order_flag%TYPE

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

508: -- changes for TSO --
509:
510: TYPE tShippableItemFlag IS TABLE OF cz_exv_item_master.shippable_item_flag%TYPE
511: INDEX BY BINARY_INTEGER;
512: TYPE tTransEnabledFlag IS TABLE OF cz_exv_item_master.mtl_transactions_enabled_flag%TYPE
513: INDEX BY BINARY_INTEGER;
514: TYPE tReplenishToOrderFlag IS TABLE OF cz_exv_item_master.replenish_to_order_flag%TYPE
515: INDEX BY BINARY_INTEGER;
516: TYPE tSerialNumberControlCode IS TABLE OF cz_exv_item_master.serial_number_control_code%TYPE

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

510: TYPE tShippableItemFlag IS TABLE OF cz_exv_item_master.shippable_item_flag%TYPE
511: INDEX BY BINARY_INTEGER;
512: TYPE tTransEnabledFlag IS TABLE OF cz_exv_item_master.mtl_transactions_enabled_flag%TYPE
513: INDEX BY BINARY_INTEGER;
514: TYPE tReplenishToOrderFlag IS TABLE OF cz_exv_item_master.replenish_to_order_flag%TYPE
515: INDEX BY BINARY_INTEGER;
516: TYPE tSerialNumberControlCode IS TABLE OF cz_exv_item_master.serial_number_control_code%TYPE
517: INDEX BY BINARY_INTEGER;
518:

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

512: TYPE tTransEnabledFlag IS TABLE OF cz_exv_item_master.mtl_transactions_enabled_flag%TYPE
513: INDEX BY BINARY_INTEGER;
514: TYPE tReplenishToOrderFlag IS TABLE OF cz_exv_item_master.replenish_to_order_flag%TYPE
515: INDEX BY BINARY_INTEGER;
516: TYPE tSerialNumberControlCode IS TABLE OF cz_exv_item_master.serial_number_control_code%TYPE
517: INDEX BY BINARY_INTEGER;
518:
519: TYPE tPSShippableItemFlag IS TABLE OF cz_imp_ps_nodes.shippable_item_flag%TYPE
520: INDEX BY BINARY_INTEGER;

Line 680: FROM cz_exv_item_master

676: DECODE(SHIPPABLE_ITEM_FLAG,'Y','1','N','0','0'),
677: DECODE(MTL_TRANSACTIONS_ENABLED_FLAG,'Y','1','N','0','0'),
678: DECODE(REPLENISH_TO_ORDER_FLAG,'Y','1','N','0','0'),
679: SERIAL_NUMBER_CONTROL_CODE
680: FROM cz_exv_item_master
681: WHERE organization_id = nOrg_ID
682: AND top_item_id = nTop_ID
683: AND explosion_type = sExpl_type
684: AND language = inLang

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

1805: nModelId IN NUMBER)
1806: IS
1807: xERROR BOOLEAN:=FALSE;
1808:
1809: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
1810: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1811: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1812: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1813: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;

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

1806: IS
1807: xERROR BOOLEAN:=FALSE;
1808:
1809: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
1810: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1811: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1812: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1813: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1814: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;

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

1807: xERROR BOOLEAN:=FALSE;
1808:
1809: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
1810: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1811: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1812: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1813: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1814: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1815:

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

1808:
1809: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
1810: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1811: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1812: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1813: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1814: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1815:
1816: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

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

1809: TYPE tDescription IS TABLE OF cz_exv_item_master.description%TYPE INDEX BY BINARY_INTEGER;
1810: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1811: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1812: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1813: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1814: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1815:
1816: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1817: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;

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

1810: TYPE tComponentItemId IS TABLE OF cz_exv_item_master.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1811: TYPE tOrganizationId IS TABLE OF cz_exv_item_master.organization_id%TYPE INDEX BY BINARY_INTEGER;
1812: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1813: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1814: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1815:
1816: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1817: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1818: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;

Line 1863: FROM CZ_EXV_ITEM_MASTER WHERE bom_item_type = cz_imp_ps_node.cnModel

1859: ORGANIZATION_ID, COMPONENT_ITEM_ID, EXPLOSION_TYPE,
1860: DESCRIPTION, PLAN_LEVEL, MODEL_TYPE, CONFIG_MODEL_TYPE
1861: BULK COLLECT INTO
1862: OrganizationId, ComponentItemId, ExplosionType, Description, PlanLevel, ModelType, ConfigModelType
1863: FROM CZ_EXV_ITEM_MASTER WHERE bom_item_type = cz_imp_ps_node.cnModel
1864: AND ORGANIZATION_ID=nOrg_ID
1865: AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type
1866: AND language = l_lang;
1867:

Line 3176: SELECT component_item_id, component_code FROM cz_exv_item_master

3172: inGenStatistics IN PLS_INTEGER)
3173: RETURN NUMBER IS
3174:
3175: CURSOR c_expl (inLang VARCHAR2) IS
3176: SELECT component_item_id, component_code FROM cz_exv_item_master
3177: WHERE top_item_id = inTopId
3178: AND organization_id = inOrgId
3179: AND explosion_type = inExplType
3180: AND bom_item_type = 1

Line 3762: FROM cz_exv_item_master

3758:
3759: BEGIN
3760: SELECT item_catalog_group_id, inventory_item_id
3761: BULK COLLECT INTO repCatalogGroupId, repItemId
3762: FROM cz_exv_item_master
3763: WHERE organization_id = nOrg_ID
3764: AND top_item_id = nTop_ID
3765: AND explosion_type = sExpl_type
3766: AND item_catalog_group_id IS NOT NULL