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.

[Home] [Help]

APPS.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on CZ_CONFIG_DETAILS_V

Line 56: | cz_config_details_v table. This dependency has been

52: | Modified on 10-APR-2002 By Sushant Sawant: Fixed BUG 2310435 and BUG 2312199
53: | BUG 2310435 CUSTOMER BUG is similar to 2312199 INTERNAL BUG
54: | The process_configurator_data code was dependent on the
55: | parent_config_item_id being populated in the
56: | cz_config_details_v table. This dependency has been
57: | removed and the code has been changed to properly
58: | identify the top model and the relationships to the
59: | appropriate components.This bug was identified as a
60: | common bom issue at agilent, however it is generic

Line 809: config_item_id cz_config_details_v.config_item_id%type,

805: IS
806:
807: TYPE config_data_rec_type is RECORD (
808: line_id NUMBER ,
809: config_item_id cz_config_details_v.config_item_id%type,
810: config_hdr_id cz_config_details_v.config_hdr_id%type,
811: parent_config_item_id cz_config_details_v.parent_config_item_id%type,
812: inventory_item_id cz_config_details_v.inventory_item_id%type,
813: component_code cz_config_details_v.component_code%type,

Line 810: config_hdr_id cz_config_details_v.config_hdr_id%type,

806:
807: TYPE config_data_rec_type is RECORD (
808: line_id NUMBER ,
809: config_item_id cz_config_details_v.config_item_id%type,
810: config_hdr_id cz_config_details_v.config_hdr_id%type,
811: parent_config_item_id cz_config_details_v.parent_config_item_id%type,
812: inventory_item_id cz_config_details_v.inventory_item_id%type,
813: component_code cz_config_details_v.component_code%type,
814: segment1 mtl_system_items.segment1%type,

Line 811: parent_config_item_id cz_config_details_v.parent_config_item_id%type,

807: TYPE config_data_rec_type is RECORD (
808: line_id NUMBER ,
809: config_item_id cz_config_details_v.config_item_id%type,
810: config_hdr_id cz_config_details_v.config_hdr_id%type,
811: parent_config_item_id cz_config_details_v.parent_config_item_id%type,
812: inventory_item_id cz_config_details_v.inventory_item_id%type,
813: component_code cz_config_details_v.component_code%type,
814: segment1 mtl_system_items.segment1%type,
815: component_item_id bom_inventory_components.component_item_id%type,

Line 812: inventory_item_id cz_config_details_v.inventory_item_id%type,

808: line_id NUMBER ,
809: config_item_id cz_config_details_v.config_item_id%type,
810: config_hdr_id cz_config_details_v.config_hdr_id%type,
811: parent_config_item_id cz_config_details_v.parent_config_item_id%type,
812: inventory_item_id cz_config_details_v.inventory_item_id%type,
813: component_code cz_config_details_v.component_code%type,
814: segment1 mtl_system_items.segment1%type,
815: component_item_id bom_inventory_components.component_item_id%type,
816: component_sequence_id bom_inventory_components.component_sequence_id%type,

Line 813: component_code cz_config_details_v.component_code%type,

809: config_item_id cz_config_details_v.config_item_id%type,
810: config_hdr_id cz_config_details_v.config_hdr_id%type,
811: parent_config_item_id cz_config_details_v.parent_config_item_id%type,
812: inventory_item_id cz_config_details_v.inventory_item_id%type,
813: component_code cz_config_details_v.component_code%type,
814: segment1 mtl_system_items.segment1%type,
815: component_item_id bom_inventory_components.component_item_id%type,
816: component_sequence_id bom_inventory_components.component_sequence_id%type,
817: bom_item_type bom_inventory_components.bom_item_type%type,

Line 822: uom_code cz_config_details_v.uom_code%type --bugfix 4605114

818: wip_supply_type bom_inventory_components.wip_supply_type%type,
819: component_quantity bom_inventory_components.component_quantity%type,
820: config_orgs mtl_system_items.config_orgs%type,
821: config_match mtl_system_items.config_match%type,
822: uom_code cz_config_details_v.uom_code%type --bugfix 4605114
823: ) ;
824:
825: TYPE config_data_tbl_type is table of config_data_rec_type INDEX by BINARY_INTEGER ;
826:

Line 854: from cz_config_details_v cz ,

850: cz.quantity, --bugfix 2457660
851: msi.config_orgs,
852: msi.config_match,
853: cz.uom_code --bugfix 4605114
854: from cz_config_details_v cz ,
855: bom_inventory_components bic,
856: mtl_system_items msi
857: where bic.component_sequence_id(+) = cz.component_sequence_id
858: AND msi.inventory_item_id = cz.inventory_item_id

Line 2934: , cz_config_details_v cz

2930: bic.attribute14,
2931: bic.attribute15,
2932: cz.component_code
2933: FROM bom_inventory_components bic
2934: , cz_config_details_v cz
2935: WHERE bic.bom_item_type NOT IN('1', '2')
2936: AND bic.component_sequence_id = cz.component_sequence_id
2937: AND cz.config_hdr_id = x_cz_config_hdr_id
2938: AND cz.config_rev_nbr = x_cz_config_rev_num;

Line 2995: , cz_config_details_v cz

2991: bic.attribute15
2992: FROM bom_inventory_components bic
2993: , bom_inventory_components mod_oc
2994: , bom_bill_of_materials bom
2995: , cz_config_details_v cz
2996: WHERE cz.config_hdr_id = x_cz_config_hdr_id
2997: AND cz.config_rev_nbr = x_cz_config_rev_num
2998: AND mod_oc.component_sequence_id = cz.component_sequence_id
2999: AND mod_oc.bom_item_type IN (1,2)

Line 3013: Additional table used here is bom_explosion_temp and the join to cz_config_details_v

3009: AND nvl(bic.disable_date,SYSDATE+1) > SYSDATE;
3010:
3011: /* Mandatory Components for the all the options classes in which user has chosen
3012: atleast 1 option (this is used for operation sequence inheritance from the parent)
3013: Additional table used here is bom_explosion_temp and the join to cz_config_details_v
3014: has been made using the component_code
3015: */
3016:
3017: CURSOR c_cz_req_items_with_Inherit IS

Line 3070: , cz_config_details_v cz

3066: bic.attribute15
3067: FROM bom_inventory_components bic
3068: , bom_inventory_components mod_oc
3069: , bom_bill_of_materials bom
3070: , cz_config_details_v cz
3071: , bom_explosion_temp bet
3072: WHERE cz.config_hdr_id = x_cz_config_hdr_id
3073: AND cz.config_rev_nbr = x_cz_config_rev_num
3074: AND cz.component_code = bet.component_code

Line 3089: for the records that are from cz_config_details_v (i.e all the option classes for the

3085: AND bic.effectivity_date <= SYSDATE
3086: AND nvl(bic.disable_date,SYSDATE+1) > SYSDATE;
3087:
3088: /* Components in the temp table with valid component code . Component code will be available
3089: for the records that are from cz_config_details_v (i.e all the option classes for the
3090: configured item and all the choosen options) */
3091:
3092: CURSOR c_Comps_With_ComponentCode IS
3093: SELECT * from bom_explosion_temp WHERE component_code IS NOT NULL

Line 3104: cz_config_details_v cz

3100: , bic.component_item_id
3101: , bic.operation_seq_num
3102: , cz.organization_id
3103: FROM bom_inventory_components bic,
3104: cz_config_details_v cz
3105: WHERE cz.component_sequence_id = bic.component_sequence_id
3106: AND bic.bom_item_type IN (1,2)
3107: AND bic.bill_sequence_id = l_bill_sequence_id
3108: AND cz.config_hdr_id = x_cz_config_hdr_id

Line 3466: cz_config_details_v cz

3462: from_end_item_unit_number,
3463: to_end_item_unit_number,
3464: cz.component_code
3465: FROM bom_inventory_components bic,
3466: cz_config_details_v cz
3467: WHERE bic.component_sequence_id = cz.component_sequence_id
3468: AND bic.bom_item_type IN (1,2) /* Model, Option Classes */
3469: AND cz.config_hdr_id = x_cz_config_hdr_id
3470: AND cz.config_rev_nbr = x_cz_config_rev_num;