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 516: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;

512: billSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
513: billCommonSequenceId bom_bill_of_materials.common_bill_sequence_id%TYPE;
514: useSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
515:
516: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;
517: bomDisableDate bom_inventory_components.disable_date%TYPE;
518: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
519: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
520: bomHighQuantity bom_inventory_components.high_quantity%TYPE;

Line 517: bomDisableDate bom_inventory_components.disable_date%TYPE;

513: billCommonSequenceId bom_bill_of_materials.common_bill_sequence_id%TYPE;
514: useSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
515:
516: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;
517: bomDisableDate bom_inventory_components.disable_date%TYPE;
518: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
519: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
520: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
521: bomLowQuantity bom_inventory_components.low_quantity%TYPE;

Line 518: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;

514: useSequenceId bom_bill_of_materials.bill_sequence_id%TYPE;
515:
516: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;
517: bomDisableDate bom_inventory_components.disable_date%TYPE;
518: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
519: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
520: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
521: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
522: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;

Line 519: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;

515:
516: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;
517: bomDisableDate bom_inventory_components.disable_date%TYPE;
518: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
519: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
520: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
521: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
522: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;
523: bomItemType bom_inventory_components.bom_item_type%TYPE;

Line 520: bomHighQuantity bom_inventory_components.high_quantity%TYPE;

516: bomEffectivityDate bom_inventory_components.effectivity_date%TYPE;
517: bomDisableDate bom_inventory_components.disable_date%TYPE;
518: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
519: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
520: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
521: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
522: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;
523: bomItemType bom_inventory_components.bom_item_type%TYPE;
524: bomOptional bom_inventory_components.optional%TYPE;

Line 521: bomLowQuantity bom_inventory_components.low_quantity%TYPE;

517: bomDisableDate bom_inventory_components.disable_date%TYPE;
518: bomComponentQuantity bom_inventory_components.component_quantity%TYPE;
519: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
520: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
521: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
522: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;
523: bomItemType bom_inventory_components.bom_item_type%TYPE;
524: bomOptional bom_inventory_components.optional%TYPE;
525: ---------------------------------------------------------------------------------------

Line 522: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;

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

Line 523: bomItemType bom_inventory_components.bom_item_type%TYPE;

519: bomComponentSeqId bom_inventory_components.component_sequence_id%TYPE;
520: bomHighQuantity bom_inventory_components.high_quantity%TYPE;
521: bomLowQuantity bom_inventory_components.low_quantity%TYPE;
522: bomMutuallyExclusive bom_inventory_components.mutually_exclusive_options%TYPE;
523: bomItemType bom_inventory_components.bom_item_type%TYPE;
524: bomOptional bom_inventory_components.optional%TYPE;
525: ---------------------------------------------------------------------------------------
526: --build_structure_map->execute_model->execute_structure_map->verify_children_list->hash_item
527:

Line 524: bomOptional bom_inventory_components.optional%TYPE;

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

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

804: OPEN getBillChildren FOR
805: 'SELECT i.inventory_item_id, i.concatenated_segments, b.effectivity_date, b.disable_date, b.component_quantity,' ||
806: ' b.component_sequence_id, b.high_quantity, b.low_quantity, b.mutually_exclusive_options,' ||
807: ' b.bom_item_type, b.optional, i.item_catalog_group_id' ||
808: ' FROM mtl_system_items_vl' || targetLinkName || ' i, bom_inventory_components' || targetLinkName || ' b' ||
809: ' WHERE b.bill_sequence_id = :1' ||
810: ' AND b.implementation_date IS NOT NULL' ||
811: ' AND i.organization_id = :2' ||
812: ' AND (b.optional = :3 OR b.bom_item_type <= :4)' ||

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

827:
828: IF(bomDisableDate IS NULL OR bomDisableDate > EpochEndDate)THEN bomDisableDate := EpochEndDate; END IF;
829: IF(bomEffectivityDate < EpochBeginDate)THEN bomEffectivityDate := EpochBeginDate; END IF;
830:
831: --bom_inventory_components.optional can be null which means optional. Also we need to
832: --invert the value to compare to cz_ps_nodes.bom_required_flag.
833:
834: IF(bomOptional = ORACLE_NO)THEN
835: bomRequiredFlag := FLAG_BOM_REQUIRED;