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.CTO_OSS_SOURCE_PK dependencies on BOM_CTO_ORDER_LINES

Line 319: l_perform_match bom_cto_order_lines.perform_match%type;

315: x_msg_data OUT NOCOPY Varchar) is
316:
317:
318:
319: l_perform_match bom_cto_order_lines.perform_match%type;
320: l_reuse_config bom_cto_order_lines.reuse_config%type;
321: l_oss_defined Varchar2(1);
322: i Number;
323: x_exp_error_code Number;

Line 320: l_reuse_config bom_cto_order_lines.reuse_config%type;

316:
317:
318:
319: l_perform_match bom_cto_order_lines.perform_match%type;
320: l_reuse_config bom_cto_order_lines.reuse_config%type;
321: l_oss_defined Varchar2(1);
322: i Number;
323: x_exp_error_code Number;
324: l_stmt_num Number;

Line 341: l_program_id bom_cto_order_lines.program_id%type;

337: -- Added by Renga Kannan on 11/30/04 for bug 3896824
338: -- Added the following variable declaration
339:
340: l_ship_from_org_id oe_order_lines.ship_from_org_id%type;
341: l_program_id bom_cto_order_lines.program_id%type;
342: l_valid_preconfig_org varchar2(1);
343:
344: -- End of change for bug 3896824 on 11/30/04
345:

Line 440: /* Changed the bom_cto_order_lines reference to bom_cto_order_lines_gt */

436: End if;
437:
438: l_stmt_num := 40;
439:
440: /* Changed the bom_cto_order_lines reference to bom_cto_order_lines_gt */
441:
442: -- Modified by Renga Kannan on 11/30/04 for bug 3896824
443: -- fetched two other columns ship_from_org_id and program_id into the variables
444: -- l_ship_from_org_id and l_program_id

Line 457: from bom_cto_order_lines_gt bcol

453: l_reuse_config,
454: l_config_creation,
455: l_ship_from_org_id,
456: l_program_id
457: from bom_cto_order_lines_gt bcol
458: where line_id = p_ato_line_id;
459:
460: -- End of change for bug 3896824 on 11/30/04
461:

Line 489: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

485:
486: /* Fixed the following sql to get the from orbitrary org istead of
487: going to specific ship from org */
488:
489: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
490: option_specific_sourced
491: into l_option_specific
492: from mtl_system_items msi,
493: bom_cto_order_lines_gt bcol

Line 493: bom_cto_order_lines_gt bcol

489: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
490: option_specific_sourced
491: into l_option_specific
492: from mtl_system_items msi,
493: bom_cto_order_lines_gt bcol
494: where msi.inventory_item_id = bcol.config_item_id
495: and line_id = p_ato_line_id
496: and rownum =1; /* Bugfix 3472654 */
497:

Line 499: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

495: and line_id = p_ato_line_id
496: and rownum =1; /* Bugfix 3472654 */
497:
498: if l_option_specific is not null then
499: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
500: 'Y'
501: into l_valid_ship_from_org
502: from bom_cto_order_lines_gt bcol,
503: mtl_system_items msi

Line 502: from bom_cto_order_lines_gt bcol,

498: if l_option_specific is not null then
499: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
500: 'Y'
501: into l_valid_ship_from_org
502: from bom_cto_order_lines_gt bcol,
503: mtl_system_items msi
504: where line_id = p_ato_line_id
505: and msi.inventory_item_id = bcol.config_item_id
506: and msi.organization_id = bcol.ship_from_org_id

Line 546: from bom_cto_order_lines_gt bcol,

542: l_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID Then
543: Begin
544: Select 'x'
545: into l_valid_preconfig_org
546: from bom_cto_order_lines_gt bcol,
547: mtl_system_items msi
548: where line_id = p_ato_line_id
549: and msi.inventory_item_id = bcol.config_item_id
550: and msi.organization_id = bcol.ship_from_org_id

Line 613: update bom_cto_order_lines_gt bcolgt

609:
610: */
611:
612: /* Commenting out this update sql as part of bugfix 8894392(FP:7520529).
613: update bom_cto_order_lines_gt bcolgt
614: set option_specific = (select option_specific_sourced
615: from mtl_system_items
616: where inventory_item_id = bcolgt.config_item_id
617: and rownum = 1)

Line 677: update /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

673: -- Adding the p_mode condition as part of Bugfix 8894392. Didn't want to disturb the behaviour for ACC
674: -- although I don't think this will ever get executed for CIB = 3 and matched configs because of bypass
675: -- condition. For UPG, we are doing the complete processing again. So don't need this.
676: if p_mode = 'ACC' then
677: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
678: bom_cto_order_lines_gt bcol
679: set bcol.option_specific = (select msi.option_specific_sourced
680: from mtl_system_items msi
681: where msi.inventory_item_id = bcol.config_item_id

Line 678: bom_cto_order_lines_gt bcol

674: -- although I don't think this will ever get executed for CIB = 3 and matched configs because of bypass
675: -- condition. For UPG, we are doing the complete processing again. So don't need this.
676: if p_mode = 'ACC' then
677: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
678: bom_cto_order_lines_gt bcol
679: set bcol.option_specific = (select msi.option_specific_sourced
680: from mtl_system_items msi
681: where msi.inventory_item_id = bcol.config_item_id
682: and rownum =1)

Line 752: update bom_cto_order_lines bcol

748:
749: /* Renga: Add Validation to ship from org check */
750:
751: If p_mode = 'ACC' then
752: update bom_cto_order_lines bcol
753: set option_specific = (select /*+ INDEX (bcol_gt BOM_CTO_ORDER_LINES_GT_U1) */
754: decode(option_specific,'4','3',option_specific)
755: from bom_cto_order_lines_gt bcol_gt
756: where bcol_gt.line_id = bcol.line_id)

Line 753: set option_specific = (select /+ INDEX (bcol_gt BOM_CTO_ORDER_LINES_GT_U1) /

749: /* Renga: Add Validation to ship from org check */
750:
751: If p_mode = 'ACC' then
752: update bom_cto_order_lines bcol
753: set option_specific = (select /*+ INDEX (bcol_gt BOM_CTO_ORDER_LINES_GT_U1) */
754: decode(option_specific,'4','3',option_specific)
755: from bom_cto_order_lines_gt bcol_gt
756: where bcol_gt.line_id = bcol.line_id)
757: where bcol.ato_line_id = p_ato_line_id;

Line 755: from bom_cto_order_lines_gt bcol_gt

751: If p_mode = 'ACC' then
752: update bom_cto_order_lines bcol
753: set option_specific = (select /*+ INDEX (bcol_gt BOM_CTO_ORDER_LINES_GT_U1) */
754: decode(option_specific,'4','3',option_specific)
755: from bom_cto_order_lines_gt bcol_gt
756: where bcol_gt.line_id = bcol.line_id)
757: where bcol.ato_line_id = p_ato_line_id;
758: elsif p_mode = 'UPG' then
759: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_UPG_N4) */ bom_cto_order_lines_upg bcol

Line 759: update /+ INDEX (bcol BOM_CTO_ORDER_LINES_UPG_N4) / bom_cto_order_lines_upg bcol

755: from bom_cto_order_lines_gt bcol_gt
756: where bcol_gt.line_id = bcol.line_id)
757: where bcol.ato_line_id = p_ato_line_id;
758: elsif p_mode = 'UPG' then
759: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_UPG_N4) */ bom_cto_order_lines_upg bcol
760: set option_specific = (select /*+ INDEX (bcol_gt BOM_CTO_ORDER_LINES_GT_U1) */
761: decode(option_specific,'4','3',option_specific)
762: from bom_cto_order_lines_gt bcol_gt
763: where bcol_gt.line_id = bcol.line_id)

Line 760: set option_specific = (select /+ INDEX (bcol_gt BOM_CTO_ORDER_LINES_GT_U1) /

756: where bcol_gt.line_id = bcol.line_id)
757: where bcol.ato_line_id = p_ato_line_id;
758: elsif p_mode = 'UPG' then
759: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_UPG_N4) */ bom_cto_order_lines_upg bcol
760: set option_specific = (select /*+ INDEX (bcol_gt BOM_CTO_ORDER_LINES_GT_U1) */
761: decode(option_specific,'4','3',option_specific)
762: from bom_cto_order_lines_gt bcol_gt
763: where bcol_gt.line_id = bcol.line_id)
764: where bcol.ato_line_id = p_ato_line_id;

Line 762: from bom_cto_order_lines_gt bcol_gt

758: elsif p_mode = 'UPG' then
759: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_UPG_N4) */ bom_cto_order_lines_upg bcol
760: set option_specific = (select /*+ INDEX (bcol_gt BOM_CTO_ORDER_LINES_GT_U1) */
761: decode(option_specific,'4','3',option_specific)
762: from bom_cto_order_lines_gt bcol_gt
763: where bcol_gt.line_id = bcol.line_id)
764: where bcol.ato_line_id = p_ato_line_id;
765: end if;
766:

Line 786: into /+ INDEX(bcol BOM_CTO_ORDER_LINES_GT_U1) /

782: -- bac's organization_id as ship_from_org_id. We will probably have to think about this later.
783:
784: Begin
785: select 'Y'
786: into /*+ INDEX(bcol BOM_CTO_ORDER_LINES_GT_U1) */
787: l_valid_ship_from_org
788: from bom_cto_order_lines_gt bcol
789: where line_id = p_ato_line_id
790: and (option_specific is null

Line 788: from bom_cto_order_lines_gt bcol

784: Begin
785: select 'Y'
786: into /*+ INDEX(bcol BOM_CTO_ORDER_LINES_GT_U1) */
787: l_valid_ship_from_org
788: from bom_cto_order_lines_gt bcol
789: where line_id = p_ato_line_id
790: and (option_specific is null
791: or ship_from_org_id in (select /*+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N2) */
792: rcv_org_id

Line 985: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) /

981:
982:
983: l_stmt_num := 10;
984:
985: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) */
986: count(*)
987: into l_comp_count
988: from bom_cto_oss_components ossc,
989: bom_cto_order_lines_gt bcol

Line 989: bom_cto_order_lines_gt bcol

985: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) */
986: count(*)
987: into l_comp_count
988: from bom_cto_oss_components ossc,
989: bom_cto_order_lines_gt bcol
990: where ossc.model_item_id = p_model_item_id
991: and ossc.option_item_id = bcol.inventory_item_id
992: and bcol.parent_ato_line_id = p_model_line_id
993: and exists (select 'x' from bom_cto_oss_orgs_list ossl

Line 1019: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) /

1015: organization_id, /* Organization Id */
1016: ato_line_id /* Ato line id */
1017: )
1018:
1019: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) */
1020: p_model_line_id Line_id,
1021: p_model_item_id inventory_item_id,
1022: ossl.organization_id organization_id,
1023: p_ato_line_id

Line 1027: bom_cto_order_lines_gt bcol

1023: p_ato_line_id
1024:
1025: from bom_cto_oss_components ossc,
1026: bom_cto_oss_orgs_list ossl,
1027: bom_cto_order_lines_gt bcol
1028:
1029: where
1030: ossc.model_item_id = p_model_item_id
1031: and ossc.option_item_id = bcol.inventory_item_id

Line 1064: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) /

1060: vendor_site_code,
1061: ato_line_id )
1062:
1063:
1064: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) */
1065: p_model_line_id line_id,
1066: p_model_item_id inventory_item_id,
1067: ossl.vendor_id vendor_id,
1068: decode(ossl.vendor_site_code,null,'-1',

Line 1074: bom_cto_order_lines_gt bcol

1070: p_ato_line_id ato_line_id
1071:
1072: from bom_cto_oss_components ossc,
1073: bom_cto_oss_orgs_list ossl,
1074: bom_cto_order_lines_gt bcol
1075:
1076: where
1077: bcol.parent_ato_line_id = p_model_line_id
1078: and ossc.model_item_id = p_model_item_id

Line 1425: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

1421: --Bugfix 13362916: Adding a new variable
1422: l_cnt Number;
1423: Begin
1424:
1425: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
1426: option_specific
1427: into l_option_specific
1428: from bom_cto_order_lines_gt
1429: where line_id = p_model_line_id;

Line 1428: from bom_cto_order_lines_gt

1424:
1425: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
1426: option_specific
1427: into l_option_specific
1428: from bom_cto_order_lines_gt
1429: where line_id = p_model_line_id;
1430:
1431: If l_option_specific = '2' then
1432: update /*+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N2) */

Line 1466: select /+ INDEX(bcol BOM_CTO_ORDER_LINES_GT_N3) /

1462: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG: p_calling_mode::' || p_calling_mode,5);
1463: End if;
1464:
1465:
1466: select /*+ INDEX(bcol BOM_CTO_ORDER_LINES_GT_N3) */
1467: count(*)
1468: into l_oss_child_count
1469: from bom_cto_order_lines_gt bcol
1470: where parent_ato_line_id = p_model_line_id

Line 1469: from bom_cto_order_lines_gt bcol

1465:
1466: select /*+ INDEX(bcol BOM_CTO_ORDER_LINES_GT_N3) */
1467: count(*)
1468: into l_oss_child_count
1469: from bom_cto_order_lines_gt bcol
1470: where parent_ato_line_id = p_model_line_id
1471: and line_id <> p_model_line_id /* We should igonre the current row */
1472: and option_specific in ('1','2','3')
1473: --Bugfix 13540153-FP(13360098)

Line 1525: from (select /+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N2) INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) /

1521: p_model_item_id,
1522: p_model_line_id,
1523: organization_id,
1524: p_ato_line_id
1525: from (select /*+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N2) INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) */
1526: oss_src.line_id line_id,
1527: oss_src.rcv_org_id organization_id
1528: from bom_cto_oss_source_gt oss_src,
1529: bom_cto_order_lines_gt bcol

Line 1529: bom_cto_order_lines_gt bcol

1525: from (select /*+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N2) INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) */
1526: oss_src.line_id line_id,
1527: oss_src.rcv_org_id organization_id
1528: from bom_cto_oss_source_gt oss_src,
1529: bom_cto_order_lines_gt bcol
1530: where bcol.parent_ato_line_id = p_model_line_id
1531: and bcol.parent_ato_line_id <> bcol.line_id
1532: and bcol.option_specific in ('1','2','3')
1533: and oss_src.line_id = bcol.line_id

Line 1544: select /+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N2) INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) /

1540: and bcol.option_specific = '3'
1541: and nvl(valid_flag,'N') = 'Y'
1542: and rcv_org_id is null)*/
1543: Union
1544: select /*+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N2) INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) */
1545: oss_src.line_id line_id,
1546: oss_src.source_org_id organization_id
1547: from bom_cto_oss_source_gt oss_src,
1548: bom_cto_order_lines_gt bcol

Line 1548: bom_cto_order_lines_gt bcol

1544: select /*+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N2) INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) */
1545: oss_src.line_id line_id,
1546: oss_src.source_org_id organization_id
1547: from bom_cto_oss_source_gt oss_src,
1548: bom_cto_order_lines_gt bcol
1549: where bcol.parent_ato_line_id = p_model_line_id
1550: and bcol.parent_ato_line_id <> bcol.line_id
1551: and bcol.option_specific in ('1','2','3')
1552: and oss_src.line_id = bcol.line_id

Line 1574: update /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

1570: IF PG_DEBUG <> 0 THEN
1571: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG: No oss child found...Updating in bcol',1);
1572: END IF;
1573:
1574: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
1575: bom_cto_order_lines_gt bcol
1576: set option_specific = null
1577: where line_id = p_model_line_id;
1578:

Line 1575: bom_cto_order_lines_gt bcol

1571: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG: No oss child found...Updating in bcol',1);
1572: END IF;
1573:
1574: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
1575: bom_cto_order_lines_gt bcol
1576: set option_specific = null
1577: where line_id = p_model_line_id;
1578:
1579: IF PG_DEBUG <> 0 THEN

Line 1791: select /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) INDEX(bcol BOM_CTO_ORDER_LINES_GT_U1/

1787: valid_flag,
1788: leaf_node
1789: )
1790:
1791: select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) INDEX(bcol BOM_CTO_ORDER_LINES_GT_U1*/
1792: p_model_item_id,
1793: p_model_line_id,
1794: oss_lis.organization_id,
1795: oss_lis.organization_id,

Line 1808: bom_cto_order_lines_gt bcol

1804: 'Y',
1805: 'Y'
1806: from bom_cto_oss_orgslist_gt oss_lis,
1807: mtl_system_items msi,
1808: bom_cto_order_lines_gt bcol
1809: where
1810: bcol.line_id = p_model_line_id
1811: and bcol.option_specific = '3'
1812: and oss_lis.organization_id not in (

Line 1930: from bom_cto_order_lines

1926: option_specific,
1927: config_creation,
1928: perform_match,
1929: reuse_config
1930: from bom_cto_order_lines
1931: where ato_line_id = p_Ato_line_id
1932: and option_specific in ('1','2','3')
1933: and p_mode = 'ACC'
1934: union

Line 1942: from bom_cto_order_lines_upg

1938: option_specific,
1939: config_creation,
1940: perform_match,
1941: reuse_config
1942: from bom_cto_order_lines_upg
1943: where ato_line_id = p_Ato_line_id
1944: and option_specific in ('1','2','3')
1945: and p_mode = 'UPG'
1946: and (p_changed_src = 'Y' or config_creation=3);

Line 3324: from bom_cto_order_lines_upg bcol

3320: If p_mode = 'UPG' then
3321:
3322: update mtl_system_items msi
3323: set msi.option_specific_sourced = (select bcol.option_specific
3324: from bom_cto_order_lines_upg bcol
3325: where bcol.ato_line_id= p_ato_line_id
3326: and bcol.config_item_id = msi.inventory_item_id
3327: )
3328: --Bugfix 12917456: Adding a distinct. This sql otherwise returns ORA-01427 error

Line 3332: from bom_cto_order_lines_upg

3328: --Bugfix 12917456: Adding a distinct. This sql otherwise returns ORA-01427 error
3329: --when a top level config has the same child config appearing in its BOM multiple
3330: --times.
3331: where msi.inventory_item_id in (select distinct config_item_id
3332: from bom_cto_order_lines_upg
3333: where ato_line_id = p_ato_line_id
3334: and bom_item_type = 1
3335: and option_specific in ('1','2','3')
3336: );

Line 3340: from bom_cto_order_lines bcol

3336: );
3337: elsif p_mode = 'ACC' Then
3338: update mtl_system_items msi
3339: set msi.option_specific_sourced = (select bcol.option_specific
3340: from bom_cto_order_lines bcol
3341: where bcol.ato_line_id=p_ato_line_id
3342: and bcol.config_item_id =msi.inventory_item_id
3343: )
3344: where msi.inventory_item_id in (select config_item_id

Line 3345: from bom_cto_order_lines

3341: where bcol.ato_line_id=p_ato_line_id
3342: and bcol.config_item_id =msi.inventory_item_id
3343: )
3344: where msi.inventory_item_id in (select config_item_id
3345: from bom_cto_order_lines
3346: where ato_line_id = p_ato_line_id
3347: and bom_item_type = 1
3348: and option_specific in ('1','2','3')
3349: );

Line 3652: update /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

3648: End loop;
3649: Else /* X_rule_exists */
3650: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_ITEM_LEVEL_RULE: Updating bcol with option specific = 4',1);
3651:
3652: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
3653: bom_cto_order_lines_gt bcol
3654: set option_specific = 4
3655: where line_id = p_model_line_id;
3656:

Line 3653: bom_cto_order_lines_gt bcol

3649: Else /* X_rule_exists */
3650: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_ITEM_LEVEL_RULE: Updating bcol with option specific = 4',1);
3651:
3652: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
3653: bom_cto_order_lines_gt bcol
3654: set option_specific = 4
3655: where line_id = p_model_line_id;
3656:
3657: End if; /* x_rule_exists = 'Y' */

Line 3986: any input parameter. This looks at the data from bom_cto_order_lines_gt temp table

3982: */
3983:
3984: /*
3985: This procedure is called from match API during ATP. This will not have
3986: any input parameter. This looks at the data from bom_cto_order_lines_gt temp table
3987: and process all the OSS configurations to get the list of valid orgs and
3988: vendors.
3989: */
3990:

Line 4255: Select /+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N5) /

4251: x_msg_count OUT NOCOPY Number,
4252: x_msg_data OUT NOCOPY Varchar2) is
4253:
4254: Cursor Oss_top_models is
4255: Select /*+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N5) */
4256: distinct bcol1.ato_line_id
4257: from bom_cto_order_lines_gt bcol1
4258: where exists (select /*+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N3) */
4259: 'X'

Line 4257: from bom_cto_order_lines_gt bcol1

4253:
4254: Cursor Oss_top_models is
4255: Select /*+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N5) */
4256: distinct bcol1.ato_line_id
4257: from bom_cto_order_lines_gt bcol1
4258: where exists (select /*+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N3) */
4259: 'X'
4260: from bom_cto_oss_components ossc,
4261: bom_cto_order_lines_gt bcol2

Line 4258: where exists (select /+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N3) /

4254: Cursor Oss_top_models is
4255: Select /*+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N5) */
4256: distinct bcol1.ato_line_id
4257: from bom_cto_order_lines_gt bcol1
4258: where exists (select /*+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N3) */
4259: 'X'
4260: from bom_cto_oss_components ossc,
4261: bom_cto_order_lines_gt bcol2
4262: where bcol2.parent_ato_line_id = bcol1.line_id

Line 4261: bom_cto_order_lines_gt bcol2

4257: from bom_cto_order_lines_gt bcol1
4258: where exists (select /*+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N3) */
4259: 'X'
4260: from bom_cto_oss_components ossc,
4261: bom_cto_order_lines_gt bcol2
4262: where bcol2.parent_ato_line_id = bcol1.line_id
4263: and ossc.model_item_id = bcol1.inventory_item_id
4264: and ossc.option_item_id = bcol2.inventory_item_id)
4265: and bcol1.bom_item_type = '1'

Line 4274: select /+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N1) /

4270: will bring all those lines for processing
4271: */
4272:
4273: Cursor oss_models(p_ato_line_id Number) is
4274: select /*+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N1) */
4275: line_id,
4276: ato_line_id,
4277: option_specific,
4278: inventory_item_id,

Line 4282: from bom_cto_order_lines_gt

4278: inventory_item_id,
4279: config_item_id,
4280: perform_match,
4281: config_creation
4282: from bom_cto_order_lines_gt
4283: where ato_line_id = p_ato_line_id
4284: and option_specific in ('1','2','3')
4285: order by plan_level desc;
4286:

Line 4441: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

4437: organization_id,
4438: vendor_id,
4439: vendor_site_code,
4440: make_flag)
4441: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
4442: oss_src.inventory_item_id,
4443: oss_src.line_id,
4444: bcol.ato_line_id,
4445: oss_src.rcv_org_id,

Line 4452: bom_cto_order_lines_gt bcol

4448: to_number(null), --3894241
4449: null,
4450: reuse_flag
4451: from bom_cto_oss_source_gt oss_src,
4452: bom_cto_order_lines_gt bcol
4453: where bcol.line_id = oss_src.line_id
4454: and oss_error_code is null
4455: and oss_src.valid_flag = 'Y'
4456: and oss_src.rcv_org_id is not null

Line 4459: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

4455: and oss_src.valid_flag = 'Y'
4456: and oss_src.rcv_org_id is not null
4457: and nvl(bcol.option_specific,'4') <> '4'
4458: union
4459: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
4460: oss_src.inventory_item_id,
4461: oss_src.line_id,
4462: bcol.ato_line_id,
4463: oss_src.source_org_id,

Line 4470: bom_cto_order_lines_gt bcol

4466: to_number(null), --3894241
4467: null,
4468: null
4469: from bom_cto_oss_source_gt oss_src,
4470: bom_cto_order_lines_gt bcol
4471: where bcol.line_id = oss_src.line_id
4472: and bcol.option_specific is not null
4473: and oss_error_code is null
4474: and oss_src.valid_flag = 'Y'

Line 4484: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

4480: and valid_flag = 'Y'
4481: )
4482: and nvl(bcol.option_specific,'4') <> '4'
4483: union
4484: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
4485: oss_src.inventory_item_id,
4486: oss_src.line_id,
4487: bcol.ato_line_id,
4488: to_number(null),--3894241

Line 4493: bom_cto_order_lines_gt bcol

4489: oss_src.vendor_id,
4490: oss_src.vendor_site_code,
4491: null
4492: from bom_cto_oss_source_gt oss_src,
4493: bom_cto_order_lines_gt bcol
4494: where bcol.line_id = oss_src.line_id
4495: and bcol.option_specific is not null
4496: and oss_error_code is null
4497: and oss_src.valid_flag = 'Y'

Line 4611: bom_cto_order_lines_gt bcol,

4607:
4608: from mrp_sr_receipt_org rcv,
4609: mrp_sr_source_org src,
4610: mrp_sr_assignments assg,
4611: bom_cto_order_lines_gt bcol,
4612: mtl_system_items msi,
4613: ap_supplier_sites_all vend
4614:
4615: where

Line 4645: bom_cto_order_lines_gt bcol,

4641: to_number(null), --3894241
4642: null
4643:
4644: from mrp_sr_assignments assg,
4645: bom_cto_order_lines_gt bcol,
4646: mtl_system_items msi
4647:
4648: where
4649: bcol.ato_line_id = bcol.line_id

Line 4676: bom_cto_order_lines_gt bcol,

4672:
4673: from mrp_sr_receipt_org rcv,
4674: mrp_sr_source_org src,
4675: mrp_sr_assignments assg,
4676: bom_cto_order_lines_gt bcol,
4677: mtl_system_items msi,
4678: ap_supplier_sites_all vend
4679:
4680: where

Line 4713: bom_cto_order_lines_gt bcol,

4709: to_number(null),--bugfix3894241
4710: null
4711:
4712: from mrp_sr_assignments assg,
4713: bom_cto_order_lines_gt bcol,
4714: mtl_system_items msi
4715:
4716: where
4717: bcol.config_item_id is not null

Line 4803: /* The following cursor will get all the line from bom_cto_order_lines table.

4799: l_stmt_num Number ;
4800: l_rows_updated Number ; --Bugfix 6710393
4801:
4802:
4803: /* The following cursor will get all the line from bom_cto_order_lines table.
4804: This curosr is used for creating bcol cache.
4805: */
4806:
4807: Cursor bcol_cur is

Line 4808: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

4804: This curosr is used for creating bcol cache.
4805: */
4806:
4807: Cursor bcol_cur is
4808: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
4809: line_id,
4810: ato_line_id,
4811: parent_ato_line_id,
4812: option_specific,

Line 4814: from bom_cto_order_lines_gt bcol

4810: ato_line_id,
4811: parent_ato_line_id,
4812: option_specific,
4813: perform_match
4814: from bom_cto_order_lines_gt bcol
4815: where ato_line_id = p_ato_line_id;
4816:
4817:
4818: Cursor oss_line_cur is

Line 4819: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

4815: where ato_line_id = p_ato_line_id;
4816:
4817:
4818: Cursor oss_line_cur is
4819: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
4820: line_id,
4821: ato_line_id,
4822: parent_ato_line_id,
4823: option_specific

Line 4824: from bom_cto_order_lines_gt bcol

4820: line_id,
4821: ato_line_id,
4822: parent_ato_line_id,
4823: option_specific
4824: from bom_cto_order_lines_gt bcol
4825: where ato_line_id = p_ato_line_id
4826: and option_specific = '1'
4827: order by plan_level desc;
4828:

Line 4844: update /+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N1) /

4840: x_oss_exists :='Y';
4841:
4842: l_stmt_num := 10;
4843:
4844: update /*+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N1) */
4845: bom_cto_order_lines_gt bcol1
4846: set option_specific = '1'
4847: where
4848: ato_line_id = p_ato_line_id

Line 4845: bom_cto_order_lines_gt bcol1

4841:
4842: l_stmt_num := 10;
4843:
4844: update /*+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N1) */
4845: bom_cto_order_lines_gt bcol1
4846: set option_specific = '1'
4847: where
4848: ato_line_id = p_ato_line_id
4849: and exists (select /*+ INDEX (bcol2 BOM_CTO_ORDER_LINES_GT_N3) */

Line 4849: and exists (select /+ INDEX (bcol2 BOM_CTO_ORDER_LINES_GT_N3) /

4845: bom_cto_order_lines_gt bcol1
4846: set option_specific = '1'
4847: where
4848: ato_line_id = p_ato_line_id
4849: and exists (select /*+ INDEX (bcol2 BOM_CTO_ORDER_LINES_GT_N3) */
4850: 'X'
4851: from bom_cto_oss_components ossc,
4852: bom_cto_order_lines_gt bcol2,
4853: bom_cto_oss_orgs_list ossl

Line 4852: bom_cto_order_lines_gt bcol2,

4848: ato_line_id = p_ato_line_id
4849: and exists (select /*+ INDEX (bcol2 BOM_CTO_ORDER_LINES_GT_N3) */
4850: 'X'
4851: from bom_cto_oss_components ossc,
4852: bom_cto_order_lines_gt bcol2,
4853: bom_cto_oss_orgs_list ossl
4854: where bcol2.parent_ato_line_id = bcol1.line_id
4855: and ossc.model_item_id = bcol1.inventory_item_id
4856: and ossc.option_item_id = bcol2.inventory_item_id

Line 4934: Update /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

4930:
4931: l_stmt_num := 40;
4932: If g_parent_rec.line_id.count > 0 then
4933: FORALL i in g_parent_rec.line_id.first..g_parent_rec.line_id.last
4934: Update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
4935: bom_cto_order_lines_gt bcol
4936: set option_specific = g_parent_rec.option_specific(i)
4937: where line_id = g_parent_rec.line_id(i);
4938: end if;

Line 4935: bom_cto_order_lines_gt bcol

4931: l_stmt_num := 40;
4932: If g_parent_rec.line_id.count > 0 then
4933: FORALL i in g_parent_rec.line_id.first..g_parent_rec.line_id.last
4934: Update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
4935: bom_cto_order_lines_gt bcol
4936: set option_specific = g_parent_rec.option_specific(i)
4937: where line_id = g_parent_rec.line_id(i);
4938: end if;
4939:

Line 4958: --update /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

4954: -- Reasoning: This sql updates the option_specific flag for matched CIB = 3 configs based on the
4955: -- value in msi for this config. For UPG, we are doing the processing again, so we don't need this.
4956: -- Moved this outside because wanted to keep the behaviour same for ACC and we do not have the p_mode
4957: -- parameter in this procedure.
4958: --update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
4959: /* bom_cto_order_lines_gt bcol
4960: set bcol.option_specific = (select msi.option_specific_sourced
4961: from mtl_system_items msi
4962: where msi.inventory_item_id = bcol.config_item_id

Line 4959: /* bom_cto_order_lines_gt bcol

4955: -- value in msi for this config. For UPG, we are doing the processing again, so we don't need this.
4956: -- Moved this outside because wanted to keep the behaviour same for ACC and we do not have the p_mode
4957: -- parameter in this procedure.
4958: --update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
4959: /* bom_cto_order_lines_gt bcol
4960: set bcol.option_specific = (select msi.option_specific_sourced
4961: from mtl_system_items msi
4962: where msi.inventory_item_id = bcol.config_item_id
4963: and rownum =1)

Line 5213: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

5209: sr_source_id,
5210: assignment_id
5211: )
5212:
5213: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
5214: bcol.inventory_item_id,
5215: bcol.line_id,
5216: p_ato_line_id,
5217: null,

Line 5238: bom_cto_order_lines_gt bcol

5234: mrp_sr_source_org src,
5235: mrp_sr_assignments assg,
5236: mrp_sourcing_rules rule,
5237: po_vendor_sites_all vend,
5238: bom_cto_order_lines_gt bcol
5239: where
5240: assg.assignment_set_id = g_def_assg_set
5241: and bcol.ato_line_id = p_ato_line_id
5242: and bcol.config_item_id is null

Line 5281: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

5277: assignment_id,
5278: valid_flag
5279: )
5280:
5281: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
5282: bcol.inventory_item_id,
5283: bcol.line_id,
5284: p_ato_line_id,
5285: bcol.config_item_id,

Line 5307: bom_cto_order_lines_gt bcol

5303: mrp_sr_source_org src,
5304: mrp_sr_assignments assg,
5305: mrp_sourcing_rules rule,
5306: po_vendor_sites_all vend,
5307: bom_cto_order_lines_gt bcol
5308: where
5309: assg.assignment_set_id = g_def_assg_set
5310: and bcol.ato_line_id = p_ato_line_id
5311: and bcol.config_creation = 3

Line 5420: select/ /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */

5416: -- config item.
5417:
5418: -- Commenting as part of Bugfix 8894392
5419: /*cursor oss_models is
5420: select*/ /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
5421: /*line_id,
5422: ato_line_id,
5423: option_specific,
5424: inventory_item_id,

Line 5428: from bom_cto_order_lines_gt bcol

5424: inventory_item_id,
5425: config_item_id,
5426: perform_match,
5427: config_creation
5428: from bom_cto_order_lines_gt bcol
5429: where ato_line_id = p_ato_line_id
5430: and option_specific in ('1','2','3')
5431: and not (perform_match = 'Y' and config_creation = '3') -- 4093235
5432: order by plan_level desc;*/

Line 5442: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

5438: -- cursor. For mode = UPG, the the cursor picks up matched CIB = 3 configs for processing.
5439:
5440: -- Adding this cursor as part of Bugfix 8894392
5441: cursor oss_models is
5442: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
5443: line_id,
5444: ato_line_id,
5445: option_specific,
5446: inventory_item_id,

Line 5451: from bom_cto_order_lines_gt bcol

5447: config_item_id,
5448: perform_match,
5449: config_creation,
5450: plan_level
5451: from bom_cto_order_lines_gt bcol
5452: where ato_line_id = p_ato_line_id
5453: and option_specific in ('1','2','3')
5454: --Bugfix 11858888: During ATP, if match profile is OFF, the perform_match flag stays
5455: --null. The cursor doesn't pick up any lines for OSS processing resulting in wrong

Line 5464: and NOT EXISTS (SELECT 1 from bom_cto_order_lines_gt bcol2

5460: -- The current code is eliminating any child config lines that are matched, which is
5461: -- incorrect
5462: --
5463: -- and not (nvl(perform_match,'N') = 'Y' and config_creation = '3') -- 4093235
5464: and NOT EXISTS (SELECT 1 from bom_cto_order_lines_gt bcol2
5465: WHERE ato_line_id = p_ato_line_id
5466: AND ato_line_id = line_id -- indicating parent
5467: AND nvl(perform_match,'N') = 'Y'
5468: AND config_creation = '3')

Line 5471: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

5467: AND nvl(perform_match,'N') = 'Y'
5468: AND config_creation = '3')
5469: and p_calling_mode in ('ACC', 'ATP') --Bugfix 8894392: Added mode ATP in the cursor
5470: union
5471: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
5472: line_id,
5473: ato_line_id,
5474: option_specific,
5475: inventory_item_id,

Line 5480: from bom_cto_order_lines_gt bcol

5476: config_item_id,
5477: perform_match,
5478: config_creation,
5479: plan_level
5480: from bom_cto_order_lines_gt bcol
5481: where ato_line_id = p_ato_line_id
5482: and option_specific in ('1','2','3')
5483: -- and not (perform_match = 'Y' and config_creation = '3') -- 4093235
5484: -- Bugfix 8894392. In case of UPG, we need to prune the tree again. Otherwise

Line 5510: FROM bom_cto_order_lines_gt;

5506: OPTION_SPECIFIC,
5507: REUSE_CONFIG,
5508: CONFIG_CREATION,
5509: VALIDATION_ORG
5510: FROM bom_cto_order_lines_gt;
5511:
5512: Begin
5513: x_return_status := FND_API.G_RET_STS_SUCCESS;
5514: l_stmt_num := 10;

Line 5525: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS: Printing bom_cto_order_lines_gt data ' || P_ato_line_id,5);

5521: End if;
5522: -- bug 13324638
5523: If PG_DEBUG <> 0 Then
5524: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS: =======================================================',5);
5525: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS: Printing bom_cto_order_lines_gt data ' || P_ato_line_id,5);
5526: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS: =======================================================',5);
5527: oe_debug_pub.add(lpad(' ',g_pg_level)||'ATO_LINE_ID, CONFIG_ITEM_ID, INVENTORY_ITEM_ID, LINE_ID, LINK_TO_LINE_ID, '||
5528: 'PARENT_ATO_LINE_ID, PERFORM_MATCH, PLAN_LEVEL, SHIP_FROM_ORG_ID, TOP_MODEL_LINE_ID, '||
5529: 'HEADER_ID, OPTION_SPECIFIC, REUSE_CONFIG, VALIDATION_ORG',5);

Line 5614: update /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

5610:
5611: If x_exp_error_code <> 0 Then
5612: l_stmt_num :=80;
5613:
5614: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
5615: bom_cto_order_lines_gt bcol
5616: set oss_error_code = x_exp_error_code
5617: where line_id = oss_model_rec.line_id;
5618:

Line 5615: bom_cto_order_lines_gt bcol

5611: If x_exp_error_code <> 0 Then
5612: l_stmt_num :=80;
5613:
5614: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
5615: bom_cto_order_lines_gt bcol
5616: set oss_error_code = x_exp_error_code
5617: where line_id = oss_model_rec.line_id;
5618:
5619: If PG_DEBUG <> 0 Then

Line 5627: update /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

5623: If oss_model_rec.line_id <> oss_model_rec.ato_line_id then
5624:
5625: l_stmt_num := 90;
5626:
5627: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
5628: bom_cto_order_lines_gt bcol
5629: Set oss_error_code = 360
5630: where line_id = oss_model_rec.ato_line_id;
5631: exit;

Line 5628: bom_cto_order_lines_gt bcol

5624:
5625: l_stmt_num := 90;
5626:
5627: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
5628: bom_cto_order_lines_gt bcol
5629: Set oss_error_code = 360
5630: where line_id = oss_model_rec.ato_line_id;
5631: exit;
5632:

Line 5689: update /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

5685: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
5686:
5687: If x_exp_error_code <> 0 Then
5688: l_stmt_num := 120;
5689: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
5690: bom_cto_order_lines_gt bcol
5691: set oss_error_code = x_exp_error_code
5692: where line_id = oss_model_rec.line_id;
5693:

Line 5690: bom_cto_order_lines_gt bcol

5686:
5687: If x_exp_error_code <> 0 Then
5688: l_stmt_num := 120;
5689: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
5690: bom_cto_order_lines_gt bcol
5691: set oss_error_code = x_exp_error_code
5692: where line_id = oss_model_rec.line_id;
5693:
5694: If PG_DEBUG <> 0 Then

Line 5700: update /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

5696: End if;
5697:
5698: If oss_model_rec.line_id <> oss_model_rec.ato_line_id then
5699: l_stmt_num := 130;
5700: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
5701: bom_cto_order_lines_gt bcol
5702: set oss_error_code = 360
5703: where line_id = oss_model_rec.ato_line_id;
5704: If PG_DEBUG <> 0 Then

Line 5701: bom_cto_order_lines_gt bcol

5697:
5698: If oss_model_rec.line_id <> oss_model_rec.ato_line_id then
5699: l_stmt_num := 130;
5700: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
5701: bom_cto_order_lines_gt bcol
5702: set oss_error_code = 360
5703: where line_id = oss_model_rec.ato_line_id;
5704: If PG_DEBUG <> 0 Then
5705: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS: setting parent model error code to 360',5);

Line 5771: delete /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

5767: If pg_debug <> 0 Then
5768: oe_debug_pub.add(lpad(' ',g_pg_level)||'COPY_TO_BCOL_TEMP: Inside Copy to Bcol Temp API',5);
5769: end if;
5770:
5771: delete /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
5772: from bom_cto_order_lines_gt bcol
5773: where ato_line_id = p_ato_line_id;
5774:
5775: INSERT into bom_cto_order_lines_gt(

Line 5772: from bom_cto_order_lines_gt bcol

5768: oe_debug_pub.add(lpad(' ',g_pg_level)||'COPY_TO_BCOL_TEMP: Inside Copy to Bcol Temp API',5);
5769: end if;
5770:
5771: delete /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
5772: from bom_cto_order_lines_gt bcol
5773: where ato_line_id = p_ato_line_id;
5774:
5775: INSERT into bom_cto_order_lines_gt(
5776: ATO_LINE_ID,

Line 5775: INSERT into bom_cto_order_lines_gt(

5771: delete /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
5772: from bom_cto_order_lines_gt bcol
5773: where ato_line_id = p_ato_line_id;
5774:
5775: INSERT into bom_cto_order_lines_gt(
5776: ATO_LINE_ID,
5777: BATCH_ID,
5778: BOM_ITEM_TYPE,
5779: COMPONENT_CODE,

Line 5802: Select /+ INDEX (bcol_upg BOM_CTO_ORDER_LINES_UPG_N4) /

5798: QTY_PER_PARENT_MODEL,
5799: CONFIG_CREATION,
5800: program_id --Bugfix 8894392
5801: )
5802: Select /*+ INDEX (bcol_upg BOM_CTO_ORDER_LINES_UPG_N4) */
5803: ATO_LINE_ID,
5804: BATCH_ID,
5805: BOM_ITEM_TYPE,
5806: COMPONENT_CODE,

Line 5829: from bom_cto_order_lines_upg bcol_upg

5825: QTY_PER_PARENT_MODEL,
5826: CONFIG_CREATION,
5827: program_id --Bugfix 8894392
5828:
5829: from bom_cto_order_lines_upg bcol_upg
5830: where ato_line_id = p_ato_line_id;
5831:
5832:
5833: If PG_DEBUG <> 0 Then

Line 5852: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

5848: x_return_status OUT NOCOPY Varchar2,
5849: x_msg_count OUT NOCOPY Number,
5850: x_msg_data OUT NOCOPY Varchar2) is
5851: cursor model_lines_cur is
5852: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
5853: line_id,
5854: inventory_item_id,
5855: option_specific,
5856: parent_ato_line_id,

Line 5858: from bom_cto_order_lines_gt bcol

5854: inventory_item_id,
5855: option_specific,
5856: parent_ato_line_id,
5857: ato_line_id
5858: from bom_cto_order_lines_gt bcol
5859: where ato_line_id = p_ato_line_id
5860: and nvl(wip_supply_type,-1) <> '6'
5861: and bom_item_type = '1'
5862: and option_specific in ('1','2','3')

Line 5895: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) /

5891: line_id,
5892: organization_id,
5893: ato_line_id
5894: )
5895: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
5896: -1,
5897: ship_from_org_id,
5898: p_ato_line_id
5899: from bom_cto_order_lines_gt bcol

Line 5899: from bom_cto_order_lines_gt bcol

5895: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
5896: -1,
5897: ship_from_org_id,
5898: p_ato_line_id
5899: from bom_cto_order_lines_gt bcol
5900: where line_id = p_ato_line_id;
5901:
5902: l_stmt_num := 20;
5903:

Line 6037: select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

6033: sr_source_id,
6034: assignment_id
6035: )
6036:
6037: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
6038: bcol.inventory_item_id,
6039: bcol.line_id,
6040: p_ato_line_id,
6041: null,

Line 6062: bom_cto_order_lines_gt bcol

6058: mrp_sr_source_org src,
6059: mrp_sr_assignments assg,
6060: mrp_sourcing_rules rule,
6061: po_vendor_sites_all vend,
6062: bom_cto_order_lines_gt bcol
6063: where
6064: assg.assignment_set_id = g_def_assg_set
6065: and bcol.ato_line_id = p_ato_line_id
6066: and bcol.config_creation = 3

Line 6123: --select /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) /

6119: assignment_id,
6120: Valid_flag /* 4093235 */
6121: --)
6122:
6123: --select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
6124: /* bcol.inventory_item_id,
6125: bcol.line_id,
6126: p_ato_line_id,
6127: bcol.config_item_id,

Line 6149: bom_cto_order_lines_gt bcol

6145: mrp_sr_source_org src,
6146: mrp_sr_assignments assg,
6147: mrp_sourcing_rules rule,
6148: po_vendor_sites_all vend,
6149: bom_cto_order_lines_gt bcol
6150: where
6151: assg.assignment_set_id = g_def_assg_set
6152: and bcol.ato_line_id = p_ato_line_id
6153: and bcol.config_creation = 3