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.CSTPSCCR dependencies on BOM_INVENTORY_COMPONENTS

Line 1887: BOM_INVENTORY_COMPONENTS bic,

1883: DECODE(cicd.cost_element_id, 3, cicd.resource_seq_num,
1884: 4, cicd.resource_seq_num,
1885: 5, cicd.resource_seq_num, null), null), null), null)
1886: FROM BOM_BILL_OF_MATERIALS bbom,
1887: BOM_INVENTORY_COMPONENTS bic,
1888: CST_ITEM_COSTS cia_assy,
1889: CST_ITEM_COST_DETAILS cicd,
1890: CST_ITEM_COSTS cia_comp,
1891: BOM_PARAMETERS bp,

Line 1952: FROM BOM_INVENTORY_COMPONENTS bic1

1948: OR (
1949: unimp_flag = 1
1950: AND bic.EFFECTIVITY_DATE =
1951: (SELECT /*+ PUSH_SUBQ */ MAX(bic1.EFFECTIVITY_DATE) -- Added hint for 5678464
1952: FROM BOM_INVENTORY_COMPONENTS bic1
1953: WHERE bic1.COMPONENT_ITEM_ID = bic.COMPONENT_ITEM_ID
1954: AND NVL( bic1.eco_for_production, 2 ) = 2
1955: AND bic1.BILL_SEQUENCE_ID = bic.BILL_SEQUENCE_ID
1956: AND ((bic1.OPERATION_SEQ_NUM = bic.OPERATION_SEQ_NUM)

Line 3173: DELETE BOM_INVENTORY_COMPONENTS bic

3169:
3170:
3171: sql_stmt_num := 10;
3172: if l_snapshot_designator <> NVL(alt_bom_designator,(l_snapshot_designator||'_NOT')) THEN
3173: DELETE BOM_INVENTORY_COMPONENTS bic
3174: WHERE bic.BILL_SEQUENCE_ID IN
3175: (SELECT bic2.BILL_SEQUENCE_ID
3176: FROM BOM_INVENTORY_COMPONENTS bic2,
3177: BOM_BILL_OF_MATERIALS bbom,

Line 3176: FROM BOM_INVENTORY_COMPONENTS bic2,

3172: if l_snapshot_designator <> NVL(alt_bom_designator,(l_snapshot_designator||'_NOT')) THEN
3173: DELETE BOM_INVENTORY_COMPONENTS bic
3174: WHERE bic.BILL_SEQUENCE_ID IN
3175: (SELECT bic2.BILL_SEQUENCE_ID
3176: FROM BOM_INVENTORY_COMPONENTS bic2,
3177: BOM_BILL_OF_MATERIALS bbom,
3178: CST_SC_LOW_LEVEL_CODES csllc,
3179: cst_sc_sourcing_rules cssr
3180: WHERE csllc.ROLLUP_ID = l_rollup_id

Line 3197: FROM BOM_INVENTORY_COMPONENTS bic

3193: sql_stmt_num := 15;
3194: DELETE BOM_REFERENCE_DESIGNATORS brd
3195: WHERE NOT EXISTS
3196: (SELECT 'Component Header exists'
3197: FROM BOM_INVENTORY_COMPONENTS bic
3198: WHERE bic.COMPONENT_SEQUENCE_ID = brd.COMPONENT_SEQUENCE_ID);
3199:
3200: sql_stmt_num := 20;
3201: DELETE BOM_SUBSTITUTE_COMPONENTS bsc

Line 3204: FROM BOM_INVENTORY_COMPONENTS bic

3200: sql_stmt_num := 20;
3201: DELETE BOM_SUBSTITUTE_COMPONENTS bsc
3202: WHERE NOT EXISTS
3203: (SELECT 'Component Header exists'
3204: FROM BOM_INVENTORY_COMPONENTS bic
3205: WHERE bic.COMPONENT_SEQUENCE_ID = bsc.COMPONENT_SEQUENCE_ID);
3206:
3207: /* ADD SQL TO DELETE FROM THE BOM_BILL_OF_MATERIALS. */
3208: /*This should be done to update the WHO column of the table*/

Line 3301: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,

3297: bbom.attribute13,
3298: bbom.attribute14,
3299: bbom.attribute15,
3300: bbom.assembly_type,
3301: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
3302: bbom.common_bill_sequence_id,
3303: l_req_id,
3304: l_prg_appl_id,
3305: l_prg_id,

Line 3309: BOM_INVENTORY_COMPONENTS_S.NEXTVAL

3305: l_prg_id,
3306: l_prg_update_date,
3307: bbom.assembly_item_id,
3308: bbom.organization_id,
3309: BOM_INVENTORY_COMPONENTS_S.NEXTVAL
3310: FROM BOM_BILL_OF_MATERIALS bbom,
3311: CST_ITEM_COSTS cia,
3312: CST_SC_LOW_LEVEL_CODES csllc,
3313: cst_sc_sourcing_rules cssr

Line 3364: INSERT INTO BOM_INVENTORY_COMPONENTS

3360: and bbom2.alternate_bom_designator = l_snapshot_designator
3361: );
3362:
3363: sql_stmt_num := 40;
3364: INSERT INTO BOM_INVENTORY_COMPONENTS
3365: (
3366: OPERATION_SEQ_NUM,
3367: COMPONENT_ITEM_ID,
3368: LAST_UPDATE_DATE,

Line 3476: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,

3472: bic.LOW_QUANTITY,
3473: bic.HIGH_QUANTITY,
3474: NULL, /* ACD_TYPE */
3475: NULL,
3476: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
3477: bbom2.BILL_SEQUENCE_ID,
3478: DECODE(l_conc_flag, 1, req_id, NULL),
3479: DECODE(l_conc_flag, 1, p_prg_appl_id, NULL),
3480: DECODE(l_conc_flag, 1, p_prg_id, NULL),

Line 3492: bom_inventory_components bic,

3488: bic.PICK_COMPONENTS,
3489: bic.BOM_ITEM_TYPE
3490: FROM BOM_BILL_OF_MATERIALS bbom,
3491: BOM_BILL_OF_MATERIALS bbom2,
3492: bom_inventory_components bic,
3493: CST_ITEM_COSTS cia,
3494: CST_SC_LOW_LEVEL_CODES csllc,
3495: cst_sc_sourcing_rules cssr
3496: WHERE csllc.ROLLUP_ID = l_rollup_id

Line 3543: FROM BOM_INVENTORY_COMPONENTS bic1

3539: AND(((l_unimp_flag = 2)AND(bic.IMPLEMENTATION_DATE IS NOT NULL))
3540: OR((l_unimp_flag = 1)
3541: AND bic.EFFECTIVITY_DATE = (
3542: SELECT MAX(bic1.EFFECTIVITY_DATE)
3543: FROM BOM_INVENTORY_COMPONENTS bic1
3544: WHERE ((bic1.OPERATION_SEQ_NUM = bic.OPERATION_SEQ_NUM)
3545: OR(decode(bic1.IMPLEMENTATION_DATE, NULL,bic1.OLD_COMPONENT_SEQUENCE_ID,bic1.COMPONENT_SEQUENCE_ID) =decode(bic.IMPLEMENTATION_DATE, NULL,bic.OLD_COMPONENT_SEQUENCE_ID,bic.COMPONENT_SEQUENCE_ID))
3546: )
3547: AND bic1.BILL_SEQUENCE_ID = bic.BILL_SEQUENCE_ID

Line 3562: from bom_inventory_components bic2,

3558: and bad.alternate_designator_code = l_snapshot_designator
3559: )
3560: AND NOT EXISTS(
3561: select 'Bom exists with alternate as snapshot'
3562: from bom_inventory_components bic2,
3563: bom_bill_of_materials bbom3
3564: where bbom3.organization_id = csllc.organization_id
3565: and bbom3.assembly_item_id = cia.inventory_item_id
3566: and bbom3.alternate_bom_designator = l_snapshot_designator