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_BILL_OF_MATERIALS

Line 1885: FROM BOM_BILL_OF_MATERIALS bbom,

1881: DECODE(nvl(bic.WIP_SUPPLY_TYPE, nvl(msi.WIP_SUPPLY_TYPE,1)),6,
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,

Line 1918: FROM BOM_BILL_OF_MATERIALS bbom1

1914: OR ((alt_bom_designator IS NOT NULL)
1915: AND (bbom.ALTERNATE_BOM_DESIGNATOR IS NULL)
1916: AND NOT EXISTS
1917: (SELECT /*+ PUSH_SUBQ */ 'X' -- Added hint for 5678464
1918: FROM BOM_BILL_OF_MATERIALS bbom1
1919: WHERE bbom1.ASSEMBLY_ITEM_ID =
1920: bbom.ASSEMBLY_ITEM_ID
1921: AND bbom1.ORGANIZATION_ID = bbom.ORGANIZATION_ID
1922: AND bbom1.ALTERNATE_BOM_DESIGNATOR = alt_bom_designator

Line 3176: BOM_BILL_OF_MATERIALS bbom,

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
3180: AND cssr.rollup_id (+)= l_rollup_id

Line 3206: /* ADD SQL TO DELETE FROM THE BOM_BILL_OF_MATERIALS. */

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*/
3208: if l_snapshot_designator <> alt_bom_designator THEN
3209: sql_stmt_num:=25;
3210: Delete BOM_BILL_OF_MATERIALS bbom

Line 3210: Delete BOM_BILL_OF_MATERIALS bbom

3206: /* ADD SQL TO DELETE FROM THE BOM_BILL_OF_MATERIALS. */
3207: /*This should be done to update the WHO column of the table*/
3208: if l_snapshot_designator <> alt_bom_designator THEN
3209: sql_stmt_num:=25;
3210: Delete BOM_BILL_OF_MATERIALS bbom
3211: WHERE bbom.BILL_SEQUENCE_ID IN
3212: (SELECT bbom2.BILL_SEQUENCE_ID
3213: FROM BOM_BILL_OF_MATERIALS bbom2,
3214: CST_SC_LOW_LEVEL_CODES csllc,

Line 3213: FROM BOM_BILL_OF_MATERIALS bbom2,

3209: sql_stmt_num:=25;
3210: Delete BOM_BILL_OF_MATERIALS bbom
3211: WHERE bbom.BILL_SEQUENCE_ID IN
3212: (SELECT bbom2.BILL_SEQUENCE_ID
3213: FROM BOM_BILL_OF_MATERIALS bbom2,
3214: CST_SC_LOW_LEVEL_CODES csllc,
3215: cst_item_costs cia,
3216: cst_sc_sourcing_rules cssr
3217: WHERE csllc.ROLLUP_ID = l_rollup_id

Line 3234: INSERT INTO BOM_BILL_OF_MATERIALS(

3230: );
3231: END IF;
3232:
3233: sql_stmt_num := 30;
3234: INSERT INTO BOM_BILL_OF_MATERIALS(
3235: assembly_item_id,
3236: organization_id,
3237: alternate_bom_designator,
3238: last_update_date,

Line 3309: FROM BOM_BILL_OF_MATERIALS bbom,

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
3313: WHERE csllc.ROLLUP_ID = l_rollup_id

Line 3336: FROM BOM_BILL_OF_MATERIALS bbom1

3332: OR ((alt_bom_designator IS NOT NULL)
3333: AND (bbom.ALTERNATE_BOM_DESIGNATOR IS NULL)
3334: AND NOT EXISTS
3335: (SELECT 'X'
3336: FROM BOM_BILL_OF_MATERIALS bbom1
3337: WHERE bbom.ASSEMBLY_ITEM_ID = bbom1.ASSEMBLY_ITEM_ID
3338: AND bbom.ORGANIZATION_ID = bbom1.ORGANIZATION_ID
3339: AND bbom1.ALTERNATE_BOM_DESIGNATOR = alt_bom_designator
3340: AND((l_mfg_flag = 1

Line 3356: from bom_bill_of_materials bbom2

3352: and bad.alternate_designator_code = l_snapshot_designator
3353: )
3354: AND NOT EXISTS(
3355: select 'Bom exixts with alternate as snapshot'
3356: from bom_bill_of_materials bbom2
3357: where bbom2.assembly_item_id = cia.inventory_item_id
3358: and bbom2.organization_id = csllc.organization_id
3359: and bbom2.alternate_bom_designator = l_snapshot_designator
3360: );

Line 3489: FROM BOM_BILL_OF_MATERIALS bbom,

3485: bic.SUPPLY_LOCATOR_ID,
3486: bic.SUPPLY_SUBINVENTORY,
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,

Line 3490: BOM_BILL_OF_MATERIALS bbom2,

3486: bic.SUPPLY_SUBINVENTORY,
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

Line 3513: FROM BOM_BILL_OF_MATERIALS bbom1

3509: OR ((alt_bom_designator IS NOT NULL)
3510: AND (bbom.ALTERNATE_BOM_DESIGNATOR IS NULL)
3511: AND (NOT EXISTS
3512: (SELECT 'X'
3513: FROM BOM_BILL_OF_MATERIALS bbom1
3514: WHERE bbom.ASSEMBLY_ITEM_ID = bbom1.ASSEMBLY_ITEM_ID
3515: AND bbom.ORGANIZATION_ID = bbom1.ORGANIZATION_ID
3516: AND bbom1.ALTERNATE_BOM_DESIGNATOR =
3517: alt_bom_designator

Line 3562: bom_bill_of_materials bbom3

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
3566: and bic2.bill_sequence_id = bbom3.bill_sequence_id

Line 3573: update bom_bill_of_materials bbom

3569: /* Update the common_bill_sequence_id to bill_sequence_id for the all */
3570: /* the asemblies headers were created for */
3571:
3572: sql_stmt_num := 60;
3573: update bom_bill_of_materials bbom
3574: set bbom.common_bill_sequence_id = bbom.bill_sequence_id
3575: where EXISTS(
3576: select 1
3577: from cst_sc_low_level_codes csllc,

Line 3592: from bom_bill_of_materials bbom2

3588: and bbom.alternate_bom_designator = l_snapshot_designator
3589: and (nvl(l_snapshot_designator,'NONE') <> nvl(alt_bom_designator,'NONE')
3590: or
3591: bbom.common_bill_sequence_id = (select common_bill_sequence_id
3592: from bom_bill_of_materials bbom2
3593: where bbom2.assembly_item_id = bbom.assembly_item_id
3594: and bbom2.organization_id = bbom.organization_id
3595: and bbom2.alternate_bom_designator is null
3596: )