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_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 2939: , cz_config_details_v cz

2935: bic.attribute14,
2936: bic.attribute15,
2937: cz.component_code
2938: FROM bom_inventory_components bic
2939: , cz_config_details_v cz
2940: WHERE bic.bom_item_type NOT IN('1', '2')
2941: AND bic.component_sequence_id = cz.component_sequence_id
2942: AND cz.config_hdr_id = x_cz_config_hdr_id
2943: AND cz.config_rev_nbr = x_cz_config_rev_num;

Line 3000: , cz_config_details_v cz

2996: bic.attribute15
2997: FROM bom_inventory_components bic
2998: , bom_inventory_components mod_oc
2999: , bom_bill_of_materials bom
3000: , cz_config_details_v cz
3001: WHERE cz.config_hdr_id = x_cz_config_hdr_id
3002: AND cz.config_rev_nbr = x_cz_config_rev_num
3003: AND mod_oc.component_sequence_id = cz.component_sequence_id
3004: AND mod_oc.bom_item_type IN (1,2)

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

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

Line 3075: , cz_config_details_v cz

3071: bic.attribute15
3072: FROM bom_inventory_components bic
3073: , bom_inventory_components mod_oc
3074: , bom_bill_of_materials bom
3075: , cz_config_details_v cz
3076: , bom_explosion_temp bet
3077: WHERE cz.config_hdr_id = x_cz_config_hdr_id
3078: AND cz.config_rev_nbr = x_cz_config_rev_num
3079: AND cz.component_code = bet.component_code

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

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

Line 3109: cz_config_details_v cz

3105: , bic.component_item_id
3106: , bic.operation_seq_num
3107: , cz.organization_id
3108: FROM bom_inventory_components bic,
3109: cz_config_details_v cz
3110: WHERE cz.component_sequence_id = bic.component_sequence_id
3111: AND bic.bom_item_type IN (1,2)
3112: AND bic.bill_sequence_id = l_bill_sequence_id
3113: AND cz.config_hdr_id = x_cz_config_hdr_id

Line 3471: cz_config_details_v cz

3467: from_end_item_unit_number,
3468: to_end_item_unit_number,
3469: cz.component_code
3470: FROM bom_inventory_components bic,
3471: cz_config_details_v cz
3472: WHERE bic.component_sequence_id = cz.component_sequence_id
3473: AND bic.bom_item_type IN (1,2) /* Model, Option Classes */
3474: AND cz.config_hdr_id = x_cz_config_hdr_id
3475: AND cz.config_rev_nbr = x_cz_config_rev_num;