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 2938: FROM bom_inventory_components bic

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

Line 2997: FROM bom_inventory_components bic

2993: bic.attribute12,
2994: bic.attribute13,
2995: bic.attribute14,
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

Line 2998: , bom_inventory_components mod_oc

2994: bic.attribute13,
2995: bic.attribute14,
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

Line 3072: FROM bom_inventory_components bic

3068: bic.attribute12,
3069: bic.attribute13,
3070: bic.attribute14,
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

Line 3073: , bom_inventory_components mod_oc

3069: bic.attribute13,
3070: bic.attribute14,
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

Line 3108: FROM bom_inventory_components bic,

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

Line 3155: INSERT INTO BOM_INVENTORY_COMPONENTS

3151: DELETE from bom_explosion_temp;
3152:
3153: /* Insert Model */
3154:
3155: INSERT INTO BOM_INVENTORY_COMPONENTS
3156: (
3157: bill_sequence_id,
3158: component_sequence_id,
3159: component_item_id,

Line 3205: BOM_INVENTORY_COMPONENTS_S.nextval,

3201: implementation_date,
3202: wip_supply_type
3203: )
3204: SELECT x_bill_sequence_id,
3205: BOM_INVENTORY_COMPONENTS_S.nextval,
3206: be.Component_Item_Id,
3207: SYSDATE,
3208: 1,
3209: SYSDATE,

Line 3357: FROM bom_inventory_components

3353: implementation_date, /* Implementation Date */
3354: wip_supply_type,/* wip_supply_type */
3355: from_end_item_unit_number,
3356: to_end_item_unit_number
3357: FROM bom_inventory_components
3358: WHERE bill_sequence_id = l_Bill_Sequence_id -- Sequence_id resolved at the begining
3359: AND effectivity_date <= SYSDATE
3360: AND nvl(disable_date,SYSDATE+1) > SYSDATE
3361: AND optional = 2

Line 3470: FROM bom_inventory_components bic,

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