eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_BOM_SYNCH dependencies on BOM_INVENTORY_COMPONENTS

Line 520: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;

516: billSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
517: billCommonSequenceId bom_bill_of_materials.common_bill_sequence_id%TYPE;
518: useSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
519:
520: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;
521: bomDisableDate bom_inventory_components.disable_date%TYPE;
522: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
523: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
524: bomHighQuantity bom_inventory_components.high_quantity%TYPE;

Line 521: bomDisableDate bom_inventory_components.disable_date%TYPE;

517: billCommonSequenceId bom_bill_of_materials.common_bill_sequence_id%TYPE;
518: useSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
519:
520: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;
521: bomDisableDate bom_inventory_components.disable_date%TYPE;
522: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
523: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
524: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
525: bomLowQuantity bom_inventory_components.low_quantity%TYPE;

Line 522: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;

518: useSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
519:
520: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;
521: bomDisableDate bom_inventory_components.disable_date%TYPE;
522: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
523: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
524: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
525: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
526: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;

Line 523: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;

519:
520: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;
521: bomDisableDate bom_inventory_components.disable_date%TYPE;
522: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
523: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
524: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
525: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
526: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;
527: bomItemType bom_inventory_components.bom_item_type%TYPE;

Line 524: bomHighQuantity bom_inventory_components.high_quantity%TYPE;

520: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;
521: bomDisableDate bom_inventory_components.disable_date%TYPE;
522: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
523: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
524: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
525: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
526: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;
527: bomItemType bom_inventory_components.bom_item_type%TYPE;
528: bomOptional bom_inventory_components.optional%TYPE;

Line 525: bomLowQuantity bom_inventory_components.low_quantity%TYPE;

521: bomDisableDate bom_inventory_components.disable_date%TYPE;
522: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
523: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
524: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
525: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
526: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;
527: bomItemType bom_inventory_components.bom_item_type%TYPE;
528: bomOptional bom_inventory_components.optional%TYPE;
529: ---------------------------------------------------------------------------------------

Line 526: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;

522: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
523: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
524: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
525: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
526: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;
527: bomItemType bom_inventory_components.bom_item_type%TYPE;
528: bomOptional bom_inventory_components.optional%TYPE;
529: ---------------------------------------------------------------------------------------
530: --build_structure_map->execute_model->execute_structure_map->verify_children_list->hash_item

Line 527: bomItemType bom_inventory_components.bom_item_type%TYPE;

523: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
524: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
525: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
526: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;
527: bomItemType bom_inventory_components.bom_item_type%TYPE;
528: bomOptional bom_inventory_components.optional%TYPE;
529: ---------------------------------------------------------------------------------------
530: --build_structure_map->execute_model->execute_structure_map->verify_children_list->hash_item
531:

Line 528: bomOptional bom_inventory_components.optional%TYPE;

524: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
525: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
526: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;
527: bomItemType bom_inventory_components.bom_item_type%TYPE;
528: bomOptional bom_inventory_components.optional%TYPE;
529: ---------------------------------------------------------------------------------------
530: --build_structure_map->execute_model->execute_structure_map->verify_children_list->hash_item
531:
532: --Adds the item that passed all the comparisons to the corresponding hash tables and populates

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

815: OPEN getBillChildren FOR
816: 'SELECT i.inventory_item_id, i.concatenated_segments, b.effectivity_date, b.disable_date, b.component_quantity,' ||
817: ' b.component_sequence_id, b.high_quantity, b.low_quantity, b.mutually_exclusive_options,' ||
818: ' b.bom_item_type, b.optional, i.item_catalog_group_id' ||
819: ' FROM mtl_system_items_vl' || targetLinkName || ' i, bom_inventory_components' || targetLinkName || ' b' ||
820: ' WHERE b.bill_sequence_id = :1' ||
821: ' AND b.implementation_date IS NOT NULL' ||
822: ' AND i.organization_id = :2' ||
823: ' AND (b.optional = :3 OR b.bom_item_type <= :4)' ||

Line 842: --bom_inventory_components.optional can be null which means optional. Also we need to

838:
839: IF(bomDisableDate IS NULL OR bomDisableDate > EpochEndDate)THEN bomDisableDate := EpochEndDate; END IF;
840: IF(bomEffectivityDate < EpochBeginDate)THEN bomEffectivityDate := EpochBeginDate; END IF;
841:
842: --bom_inventory_components.optional can be null which means optional. Also we need to
843: --invert the value to compare to cz_ps_nodes.bom_required_flag.
844:
845: IF(bomOptional = ORACLE_NO)THEN
846: bomRequiredFlag := FLAG_BOM_REQUIRED;