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 BOM_INVENTORY_COMPONENTS

Line 234: -- option classes will be inserted into BOM_INVENTORY_COMPONENTS when this statement

230:
231: --
232: -- The cursor cfgdetv executing in CZLDCFGR.pld will pass the top_sequence and sort_order
233: -- values to this procedure and only the Option Classes and the option selected from the
234: -- option classes will be inserted into BOM_INVENTORY_COMPONENTS when this statement
235: -- executes.
236: --
237: INSERT INTO BOM_INVENTORY_COMPONENTS
238: (

Line 237: INSERT INTO BOM_INVENTORY_COMPONENTS

233: -- values to this procedure and only the Option Classes and the option selected from the
234: -- option classes will be inserted into BOM_INVENTORY_COMPONENTS when this statement
235: -- executes.
236: --
237: INSERT INTO BOM_INVENTORY_COMPONENTS
238: (
239: bill_sequence_id,
240: component_sequence_id,
241: component_item_id,

Line 288: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,

284: wip_supply_type
285: )
286: SELECT
287: x_bill_sequence_id,
288: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
289: be.component_item_id,
290: be.creation_date,
291: be.created_by,
292: be.last_update_date,

Line 334: bom_inventory_components bic

330: be.disable_date,
331: be.implementation_date,
332: bic.wip_supply_type
333: FROM BOM_EXPLOSIONS be,
334: bom_inventory_components bic
335: WHERE be.TOP_BILL_SEQUENCE_ID = X_Top_Bill_Sequence_Id
336: AND be.ORGANIZATION_ID = X_Organization_Id
337: AND be.EXPLOSION_TYPE = 'OPTIONAL'
338: AND be.SORT_ORDER = X_Sort_Order

Line 375: INSERT INTO BOM_INVENTORY_COMPONENTS

371: BEGIN
372:
373: -- dbms_output.put_line('Within Transfer of Components . . . ');
374:
375: INSERT INTO BOM_INVENTORY_COMPONENTS
376: (
377: bill_sequence_id,
378: component_sequence_id,
379: component_item_id,

Line 428: BOM_INVENTORY_COMPONENTS_S.nextval,

424: To_End_Item_Unit_Number
425: )
426: SELECT
427: bill_sequence_id,
428: BOM_INVENTORY_COMPONENTS_S.nextval,
429: be.Component_Item_Id,
430: SYSDATE,
431: 1,
432: SYSDATE,

Line 613: FROM bom_inventory_components bic,

609: SELECT bic.bill_sequence_id
610: , bic.component_sequence_id
611: , bic.operation_seq_num
612: , bic.component_item_id
613: FROM bom_inventory_components bic,
614: bom_bill_of_materials bom
615: WHERE -- bic.operation_seq_num = 1 AND /* Changed by Sushant on 19-Aug-2002*/
616: bic.bill_sequence_id = DECODE(bom.common_bill_sequence_id, NULL,
617: bom.bill_sequence_id, bom.common_bill_sequence_id)

Line 815: component_item_id bom_inventory_components.component_item_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,
818: wip_supply_type bom_inventory_components.wip_supply_type%type,
819: component_quantity bom_inventory_components.component_quantity%type,

Line 816: component_sequence_id bom_inventory_components.component_sequence_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,
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,

Line 817: bom_item_type bom_inventory_components.bom_item_type%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,
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,

Line 818: wip_supply_type bom_inventory_components.wip_supply_type%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,
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

Line 819: component_quantity bom_inventory_components.component_quantity%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,
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: ) ;

Line 855: bom_inventory_components bic,

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
859: AND cz.config_hdr_id = p_cz_config_hdr_id

Line 2933: FROM bom_inventory_components bic

2929: bic.attribute13,
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

Line 2992: FROM bom_inventory_components bic

2988: bic.attribute12,
2989: bic.attribute13,
2990: bic.attribute14,
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

Line 2993: , bom_inventory_components mod_oc

2989: bic.attribute13,
2990: bic.attribute14,
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

Line 3067: FROM bom_inventory_components bic

3063: bic.attribute12,
3064: bic.attribute13,
3065: bic.attribute14,
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

Line 3068: , bom_inventory_components mod_oc

3064: bic.attribute13,
3065: bic.attribute14,
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

Line 3103: FROM bom_inventory_components bic,

3099: SELECT bic.component_sequence_id
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

Line 3150: INSERT INTO BOM_INVENTORY_COMPONENTS

3146: DELETE from bom_explosion_temp;
3147:
3148: /* Insert Model */
3149:
3150: INSERT INTO BOM_INVENTORY_COMPONENTS
3151: (
3152: bill_sequence_id,
3153: component_sequence_id,
3154: component_item_id,

Line 3200: BOM_INVENTORY_COMPONENTS_S.nextval,

3196: implementation_date,
3197: wip_supply_type
3198: )
3199: SELECT x_bill_sequence_id,
3200: BOM_INVENTORY_COMPONENTS_S.nextval,
3201: be.Component_Item_Id,
3202: SYSDATE,
3203: 1,
3204: SYSDATE,

Line 3352: FROM bom_inventory_components

3348: implementation_date, /* Implementation Date */
3349: wip_supply_type,/* wip_supply_type */
3350: from_end_item_unit_number,
3351: to_end_item_unit_number
3352: FROM bom_inventory_components
3353: WHERE bill_sequence_id = l_Bill_Sequence_id -- Sequence_id resolved at the begining
3354: AND effectivity_date <= SYSDATE
3355: AND nvl(disable_date,SYSDATE+1) > SYSDATE
3356: AND optional = 2

Line 3465: FROM bom_inventory_components bic,

3461: wip_supply_type,/* wip_supply_type */
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