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 1886: BOM_INVENTORY_COMPONENTS bic,

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

Line 1951: FROM BOM_INVENTORY_COMPONENTS bic1

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

Line 3172: DELETE BOM_INVENTORY_COMPONENTS bic

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

Line 3175: FROM BOM_INVENTORY_COMPONENTS bic2,

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

Line 3196: FROM BOM_INVENTORY_COMPONENTS bic

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

Line 3203: FROM BOM_INVENTORY_COMPONENTS bic

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

Line 3300: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,

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

Line 3308: BOM_INVENTORY_COMPONENTS_S.NEXTVAL

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

Line 3363: INSERT INTO BOM_INVENTORY_COMPONENTS

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

Line 3475: BOM_INVENTORY_COMPONENTS_S.NEXTVAL,

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

Line 3491: bom_inventory_components bic,

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

Line 3542: FROM BOM_INVENTORY_COMPONENTS bic1

3538: AND(((l_unimp_flag = 2)AND(bic.IMPLEMENTATION_DATE IS NOT NULL))
3539: OR((l_unimp_flag = 1)
3540: AND bic.EFFECTIVITY_DATE = (
3541: SELECT MAX(bic1.EFFECTIVITY_DATE)
3542: FROM BOM_INVENTORY_COMPONENTS bic1
3543: WHERE ((bic1.OPERATION_SEQ_NUM = bic.OPERATION_SEQ_NUM)
3544: 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))
3545: )
3546: AND bic1.BILL_SEQUENCE_ID = bic.BILL_SEQUENCE_ID

Line 3561: from bom_inventory_components bic2,

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