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.CSTPSCEX dependencies on CST_SC_BOM_EXPLOSION

Line 40: insert into cst_sc_bom_explosion

36: /* End OPM INVCONV change */
37:
38: l_stmt_num := 10;
39:
40: insert into cst_sc_bom_explosion
41: (
42: ROLLUP_ID,
43: ASSEMBLY_ITEM_ID,
44: ASSEMBLY_ORGANIZATION_ID,

Line 385: cst_sc_bom_explosion CSBE

381: CSBE.component_item_id,
382: CSBE.component_organization_id,
383: min( CSBE.plan_level ) prior_plan_level
384: from
385: cst_sc_bom_explosion CSBE
386: where
387: CSBE.rollup_id = i_rollup_id and
388: CSBE.exploded_flag = 'N' and
389: CSBE.plan_level <= decode( i_explosion_levels, null, CSBE.plan_level+1,

Line 393: select /+ INDEX (CSBE2 CST_SC_BOM_EXPLOSION_N1)/ 'x'

389: CSBE.plan_level <= decode( i_explosion_levels, null, CSBE.plan_level+1,
390: i_explosion_levels ) and
391: not exists
392: (
393: select /*+ INDEX (CSBE2 CST_SC_BOM_EXPLOSION_N1)*/ 'x'
394: from cst_sc_bom_explosion CSBE2
395: where
396: CSBE2.rollup_id = CSBE.rollup_id and
397: CSBE2.component_item_id = CSBE.component_item_id and

Line 394: from cst_sc_bom_explosion CSBE2

390: i_explosion_levels ) and
391: not exists
392: (
393: select /*+ INDEX (CSBE2 CST_SC_BOM_EXPLOSION_N1)*/ 'x'
394: from cst_sc_bom_explosion CSBE2
395: where
396: CSBE2.rollup_id = CSBE.rollup_id and
397: CSBE2.component_item_id = CSBE.component_item_id and
398: CSBE2.component_organization_id = CSBE.component_organization_id and

Line 468: insert into cst_sc_bom_explosion

464: end if; -- i_assignment_set_id is not null
465:
466:
467: l_stmt_num := 30;
468: insert into cst_sc_bom_explosion
469: (
470: ROLLUP_ID,
471: ASSEMBLY_ITEM_ID,
472: ASSEMBLY_ORGANIZATION_ID,

Line 659: update cst_sc_bom_explosion

655:
656:
657: l_stmt_num := 40;
658:
659: update cst_sc_bom_explosion
660: set exploded_flag = 'Y'
661: where rollup_id = i_rollup_id and
662: component_item_id = CSBE.component_item_id and
663: component_organization_id = CSBE.component_organization_id;

Line 675: update cst_sc_bom_explosion CSBE

671:
672:
673: -- This will scale down the component_quantity of components of
674: -- assemblies that have partial Make sourcing rules.
675: update cst_sc_bom_explosion CSBE
676: set CSBE.component_quantity
677: = (
678: select CSBE.component_quantity *
679: nvl( sum( decode( CSSR.source_type, 2,

Line 694: update cst_sc_bom_explosion CSBE

690:
691: -- This will clear out all exploded rows, essentially the rows
692: -- that are stuck in a loop.
693: --Removed the Index N1 hint from below query as it was incorrect(Bug:9962574)
694: update cst_sc_bom_explosion CSBE
695: set exploded_flag = 'Y'
696: where
697: rollup_id = i_rollup_id and
698: exploded_flag = 'N' and

Line 700: select /+ INDEX (CSBE2 CST_SC_BOM_EXPLOSION_N1)/ 'x'

696: where
697: rollup_id = i_rollup_id and
698: exploded_flag = 'N' and
699: exists (
700: select /*+ INDEX (CSBE2 CST_SC_BOM_EXPLOSION_N1)*/ 'x'
701: from cst_sc_bom_explosion CSBE2
702: where
703: CSBE2.rollup_id = CSBE.rollup_id and
704: CSBE2.component_item_id = CSBE.component_item_id and

Line 701: from cst_sc_bom_explosion CSBE2

697: rollup_id = i_rollup_id and
698: exploded_flag = 'N' and
699: exists (
700: select /*+ INDEX (CSBE2 CST_SC_BOM_EXPLOSION_N1)*/ 'x'
701: from cst_sc_bom_explosion CSBE2
702: where
703: CSBE2.rollup_id = CSBE.rollup_id and
704: CSBE2.component_item_id = CSBE.component_item_id and
705: CSBE2.component_organization_id = CSBE.component_organization_id and

Line 978: cst_sc_bom_explosion CSBE

974: select
975: CSBE.component_item_id,
976: CSBE.component_organization_id
977: from
978: cst_sc_bom_explosion CSBE
979: where
980: CSBE.rollup_id = i_rollup_id and
981: CSBE.assembly_item_id = -1 and
982: CSBE.deleted_flag = 'Y'; -- Bug 3665428: make snapshot only for valid items without loop

Line 1067: cst_sc_bom_explosion CSBE

1063: i_prog_appl_id, -- PROGRAM_APPLICATION_ID
1064: i_prog_id, -- PROGRAM_ID
1065: sysdate -- PROGRAM_UPDATE_DATE
1066: from
1067: cst_sc_bom_explosion CSBE
1068: start with
1069: rollup_id = i_rollup_id and
1070: assembly_item_id = -1 and
1071: component_item_id = top_assm.component_item_id and

Line 1281: from cst_sc_bom_explosion CSBE,

1277: ASSM.concatenated_segments assembly_item,
1278: MP1.organization_code assembly_organization,
1279: COMP.concatenated_segments component_item,
1280: MP2.organization_code component_organization
1281: from cst_sc_bom_explosion CSBE,
1282: mtl_system_items_kfv ASSM,
1283: mtl_parameters MP1,
1284: mtl_system_items_kfv COMP,
1285: mtl_parameters MP2

Line 1354: update cst_sc_bom_explosion CSBE

1350: IF i_explosion_levels is not null THEN
1351:
1352: l_stmt_num := 5;
1353:
1354: update cst_sc_bom_explosion CSBE
1355: set deleted_flag = 'Y'
1356: where
1357: CSBE.rollup_id = i_rollup_id and
1358: CSBE.deleted_flag = 'N' and

Line 1402: cst_sc_bom_explosion CSBE

1398: i_prog_appl_id, -- PROGRAM_APPLICATION_ID
1399: i_prog_id, -- PROGRAM_ID
1400: sysdate -- PROGRAM_UPDATE_DATE
1401: from
1402: cst_sc_bom_explosion CSBE
1403: where
1404: CSBE.rollup_id = i_rollup_id and
1405: CSBE.deleted_flag = 'N' and
1406: not exists

Line 1409: from cst_sc_bom_explosion CSBE2

1405: CSBE.deleted_flag = 'N' and
1406: not exists
1407: (
1408: select 'x'
1409: from cst_sc_bom_explosion CSBE2
1410: where
1411: CSBE2.rollup_id = CSBE.rollup_id and
1412: CSBE2.assembly_item_id = CSBE.component_item_id and
1413: CSBE2.assembly_organization_id = CSBE.component_organization_id and

Line 1419: update cst_sc_bom_explosion CSBE

1415: );
1416:
1417: l_stmt_num := 20;
1418:
1419: update cst_sc_bom_explosion CSBE
1420: set deleted_flag = 'Y'
1421: where
1422: CSBE.rollup_id = i_rollup_id and
1423: CSBE.deleted_flag = 'N' and

Line 1427: from cst_sc_bom_explosion CSBE2

1423: CSBE.deleted_flag = 'N' and
1424: not exists
1425: (
1426: select 'x'
1427: from cst_sc_bom_explosion CSBE2
1428: where
1429: CSBE2.rollup_id = CSBE.rollup_id and
1430: CSBE2.assembly_item_id = CSBE.component_item_id and
1431: CSBE2.assembly_organization_id = CSBE.component_organization_id and