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 1886: FROM BOM_BILL_OF_MATERIALS bbom,

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

Line 1919: FROM BOM_BILL_OF_MATERIALS bbom1

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

Line 3177: BOM_BILL_OF_MATERIALS bbom,

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

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

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*/
3209: if l_snapshot_designator <> NVL(alt_bom_designator,(l_snapshot_designator||'_NOT')) THEN
3210: sql_stmt_num:=25;
3211: Delete BOM_BILL_OF_MATERIALS bbom

Line 3211: Delete BOM_BILL_OF_MATERIALS bbom

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

Line 3214: FROM BOM_BILL_OF_MATERIALS bbom2,

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

Line 3235: INSERT INTO BOM_BILL_OF_MATERIALS(

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

Line 3310: FROM BOM_BILL_OF_MATERIALS bbom,

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

Line 3337: FROM BOM_BILL_OF_MATERIALS bbom1

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

Line 3357: from bom_bill_of_materials bbom2

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

Line 3490: FROM BOM_BILL_OF_MATERIALS bbom,

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

Line 3491: BOM_BILL_OF_MATERIALS bbom2,

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

Line 3514: FROM BOM_BILL_OF_MATERIALS bbom1

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

Line 3563: bom_bill_of_materials bbom3

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

Line 3574: update bom_bill_of_materials bbom

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

Line 3593: from bom_bill_of_materials bbom2

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