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_OSS_ORGSLIST_GT

Line 598: delete /+ INDEX (bom_cto_oss_orgslist_gt BOM_CTO_OSS_ORGSLIST_GT_N1) /

594: delete /*+ INDEX (bom_cto_oss_source_gt BOM_CTO_OSS_SOURCE_GT_N1) */
595: from bom_cto_oss_source_gt
596: where ato_line_id = p_ato_line_id;
597:
598: delete /*+ INDEX (bom_cto_oss_orgslist_gt BOM_CTO_OSS_ORGSLIST_GT_N1) */
599: from bom_cto_oss_orgslist_gt
600: where ato_line_id = p_ato_line_id;
601:
602: /* Make a call to an API which will process this order for OSS */

Line 599: from bom_cto_oss_orgslist_gt

595: from bom_cto_oss_source_gt
596: where ato_line_id = p_ato_line_id;
597:
598: delete /*+ INDEX (bom_cto_oss_orgslist_gt BOM_CTO_OSS_ORGSLIST_GT_N1) */
599: from bom_cto_oss_orgslist_gt
600: where ato_line_id = p_ato_line_id;
601:
602: /* Make a call to an API which will process this order for OSS */
603:

Line 882: delete /+ INDEX (bom_cto_oss_orgslist_gt BOM_CTO_OSS_ORGSLIST_GT_N1) /

878: g_pg_level := g_pg_level + 3;
879: x_return_status := FND_API.G_RET_STS_SUCCESS;
880: x_exp_error_code := 0;
881:
882: delete /*+ INDEX (bom_cto_oss_orgslist_gt BOM_CTO_OSS_ORGSLIST_GT_N1) */
883: from bom_cto_oss_orgslist_gt
884: where ato_line_id = p_ato_line_id;
885:
886: /* The following sql will find out how manny componets in this

Line 883: from bom_cto_oss_orgslist_gt

879: x_return_status := FND_API.G_RET_STS_SUCCESS;
880: x_exp_error_code := 0;
881:
882: delete /*+ INDEX (bom_cto_oss_orgslist_gt BOM_CTO_OSS_ORGSLIST_GT_N1) */
883: from bom_cto_oss_orgslist_gt
884: where ato_line_id = p_ato_line_id;
885:
886: /* The following sql will find out how manny componets in this
887: configuration has OSS definition

Line 923: Insert into bom_cto_oss_orgslist_gt

919: */
920:
921: l_stmt_num := 20;
922:
923: Insert into bom_cto_oss_orgslist_gt
924: (
925: line_id, /* Model Line id */
926: inventory_item_id,/* Model item id */
927: organization_id, /* Organization Id */

Line 968: Insert into bom_cto_oss_orgslist_gt(

964: */
965:
966: l_stmt_num := 30;
967:
968: Insert into bom_cto_oss_orgslist_gt(
969: line_id,
970: inventory_item_id,
971: vendor_id,
972: vendor_site_code,

Line 1086: (select /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) /

1082: bom_cto_oss_source_gt oss_src
1083: set oss_src.valid_flag = 'Y'
1084: where oss_src.line_id = p_model_line_id
1085: and ((oss_src.source_org_id in
1086: (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
1087: organization_id
1088: from bom_cto_oss_orgslist_gt oss_lis
1089: where oss_lis.line_id = p_model_line_id)
1090: or (nvl(oss_src.vendor_id,-1),nvl(oss_src.vendor_site_code,-1)) in

Line 1088: from bom_cto_oss_orgslist_gt oss_lis

1084: where oss_src.line_id = p_model_line_id
1085: and ((oss_src.source_org_id in
1086: (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
1087: organization_id
1088: from bom_cto_oss_orgslist_gt oss_lis
1089: where oss_lis.line_id = p_model_line_id)
1090: or (nvl(oss_src.vendor_id,-1),nvl(oss_src.vendor_site_code,-1)) in
1091: (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
1092: nvl(vendor_id,-99),vendor_site_code

Line 1091: (select /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) /

1087: organization_id
1088: from bom_cto_oss_orgslist_gt oss_lis
1089: where oss_lis.line_id = p_model_line_id)
1090: or (nvl(oss_src.vendor_id,-1),nvl(oss_src.vendor_site_code,-1)) in
1091: (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
1092: nvl(vendor_id,-99),vendor_site_code
1093: from bom_cto_oss_orgslist_gt oss_lis
1094: where oss_lis.line_id = p_model_line_id)
1095: )

Line 1093: from bom_cto_oss_orgslist_gt oss_lis

1089: where oss_lis.line_id = p_model_line_id)
1090: or (nvl(oss_src.vendor_id,-1),nvl(oss_src.vendor_site_code,-1)) in
1091: (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
1092: nvl(vendor_id,-99),vendor_site_code
1093: from bom_cto_oss_orgslist_gt oss_lis
1094: where oss_lis.line_id = p_model_line_id)
1095: )
1096: )
1097: and (oss_src.rcv_org_id is null or

Line 1099: select /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) /

1095: )
1096: )
1097: and (oss_src.rcv_org_id is null or
1098: oss_src.rcv_org_id in (
1099: select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
1100: organization_id
1101: from bom_cto_oss_orgslist_gt oss_lis
1102: where line_id = p_model_line_id)
1103: );

Line 1101: from bom_cto_oss_orgslist_gt oss_lis

1097: and (oss_src.rcv_org_id is null or
1098: oss_src.rcv_org_id in (
1099: select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
1100: organization_id
1101: from bom_cto_oss_orgslist_gt oss_lis
1102: where line_id = p_model_line_id)
1103: );
1104:
1105:

Line 1141: Select /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) /

1137: source_type,
1138: valid_flag,
1139: leaf_node
1140: )
1141: Select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
1142: p_model_item_id,
1143: p_model_line_id,
1144: p_config_item_id,
1145: oss_lis.organization_id,

Line 1157: from bom_cto_oss_orgslist_gt oss_lis,

1153: 'N',
1154: 2, /* Make at source type */
1155: 'Y', /* Valid flag */
1156: 'Y' /* Leaf node */
1157: from bom_cto_oss_orgslist_gt oss_lis,
1158: mtl_system_items msi
1159: where oss_lis.organization_id not in
1160: (select /*+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N2) */
1161: nvl(rcv_org_id,-1)

Line 1238: -- Delete from bom_cto_oss_orgslist_gt;

1234: and re-use the code later
1235: */
1236:
1237: l_stmt_num := 100;
1238: -- Delete from bom_cto_oss_orgslist_gt;
1239: /* Renga: Is it required to have delete here
1240: */
1241:
1242: /* Renga: Things about match and re-use case for parent configs

Line 1378: load it to bom_cto_oss_orgslist_gt table

1374: and nvl(valid_flag,'N') = 'Y'
1375: and option_specific = '3');
1376:
1377: /* Get the intersection org from all the child oss configurations and
1378: load it to bom_cto_oss_orgslist_gt table
1379: */
1380:
1381:
1382: If PG_DEBUG <> 0 Then

Line 1390: delete /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N1) /

1386: l_stmt_num := 20;
1387: If l_oss_child_count > 0 then
1388:
1389: l_stmt_num := 30;
1390: delete /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N1) */
1391: from bom_cto_oss_orgslist_gt oss_lis
1392: where ato_line_id = p_ato_line_id;
1393: l_stmt_num := 40;
1394:

Line 1391: from bom_cto_oss_orgslist_gt oss_lis

1387: If l_oss_child_count > 0 then
1388:
1389: l_stmt_num := 30;
1390: delete /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N1) */
1391: from bom_cto_oss_orgslist_gt oss_lis
1392: where ato_line_id = p_ato_line_id;
1393: l_stmt_num := 40;
1394:
1395: insert into bom_cto_oss_orgslist_gt(

Line 1395: insert into bom_cto_oss_orgslist_gt(

1391: from bom_cto_oss_orgslist_gt oss_lis
1392: where ato_line_id = p_ato_line_id;
1393: l_stmt_num := 40;
1394:
1395: insert into bom_cto_oss_orgslist_gt(
1396: Inventory_item_id,
1397: line_id,
1398: organization_id,
1399: ato_line_id )

Line 1564: source_org_id in (select /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) /

1560: where line_id = p_model_line_id
1561: and leaf_node = 'Y'
1562: and nvl(valid_flag,'Y') <> 'N'
1563: and (source_type = 3 or
1564: source_org_id in (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
1565: organization_id
1566: from bom_cto_oss_orgslist_gt oss_list
1567: where line_id = p_model_line_id
1568: )

Line 1566: from bom_cto_oss_orgslist_gt oss_list

1562: and nvl(valid_flag,'Y') <> 'N'
1563: and (source_type = 3 or
1564: source_org_id in (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
1565: organization_id
1566: from bom_cto_oss_orgslist_gt oss_list
1567: where line_id = p_model_line_id
1568: )
1569: )
1570: Returning rcv_org_id,source_org_id Bulk collect into l_source_org_tbl,l_rcv_org_tbl;

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

1646: valid_flag,
1647: leaf_node
1648: )
1649:
1650: select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) INDEX(bcol BOM_CTO_ORDER_LINES_GT_U1*/
1651: p_model_item_id,
1652: p_model_line_id,
1653: oss_lis.organization_id,
1654: oss_lis.organization_id,

Line 1665: from bom_cto_oss_orgslist_gt oss_lis,

1661: null,
1662: 2,
1663: 'Y',
1664: 'Y'
1665: from bom_cto_oss_orgslist_gt oss_lis,
1666: mtl_system_items msi,
1667: bom_cto_order_lines_gt bcol
1668: where
1669: bcol.line_id = p_model_line_id

Line 3162: and source_org_id in (select /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) /

3158: and nvl(valid_flag,'Y') <> 'N'
3159: and
3160: (source_type = 3
3161: or ( Source_type = 2
3162: and source_org_id in (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
3163: organization_id
3164: from bom_cto_oss_orgslist_gt OSS_LIS
3165: where line_id = p_model_line_id)
3166: )

Line 3164: from bom_cto_oss_orgslist_gt OSS_LIS

3160: (source_type = 3
3161: or ( Source_type = 2
3162: and source_org_id in (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
3163: organization_id
3164: from bom_cto_oss_orgslist_gt OSS_LIS
3165: where line_id = p_model_line_id)
3166: )
3167: or ( source_type = 1
3168: and source_org_id not in

Line 3305: and rcv_org_id in (select /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) /

3301: where line_id = p_model_line_id
3302: and source_org_id = p_source_org_id
3303: and rcv_org_id = p_rcv_org_id
3304: and nvl(valid_flag,'Y') <> 'N'
3305: and rcv_org_id in (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
3306: organization_id
3307: from bom_cto_oss_orgslist_gt oss_lis
3308: where line_id = p_model_line_id);
3309:

Line 3307: from bom_cto_oss_orgslist_gt oss_lis

3303: and rcv_org_id = p_rcv_org_id
3304: and nvl(valid_flag,'Y') <> 'N'
3305: and rcv_org_id in (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
3306: organization_id
3307: from bom_cto_oss_orgslist_gt oss_lis
3308: where line_id = p_model_line_id);
3309:
3310: If sql%rowcount <> 0 then
3311: Traverse_up_tree(p_model_line_id => p_model_line_id,

Line 3342: and rcv_org_id in (select /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) /

3338: where line_id = p_model_line_id
3339: and source_org_id = p_source_org_id
3340: and rcv_org_id = p_rcv_org_id
3341: and nvl(valid_flag,'Y') <> 'N'
3342: and rcv_org_id in (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
3343: organization_id
3344: from bom_cto_oss_orgslist_gt oss_lis
3345: where line_id = p_model_line_id);
3346: If sql%rowcount <> 0 then

Line 3344: from bom_cto_oss_orgslist_gt oss_lis

3340: and rcv_org_id = p_rcv_org_id
3341: and nvl(valid_flag,'Y') <> 'N'
3342: and rcv_org_id in (select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
3343: organization_id
3344: from bom_cto_oss_orgslist_gt oss_lis
3345: where line_id = p_model_line_id);
3346: If sql%rowcount <> 0 then
3347: Traverse_up_tree(p_model_line_id => p_model_line_id,
3348: p_source_org_id => p_rcv_org_id,

Line 3506: delete from bom_cto_oss_orgslist_gt;

3502: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_OSS_ORGS_LIST: Number of records delete in source_gt = '
3503: ||sql%rowcount,5);
3504: end if;
3505:
3506: delete from bom_cto_oss_orgslist_gt;
3507:
3508: If PG_DEBUG <> 0 Then
3509: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_OSS_ORGS_LIST: Number of records delete in source_gt = '
3510: ||sql%rowcount,5);

Line 3656: from bom_cto_oss_orgslist_gt;

3652: x_oss_orgs_list.org_id,
3653: x_oss_orgs_list.vendor_id,
3654: x_oss_orgs_list.vendor_site,
3655: x_oss_orgs_list.make_flag
3656: from bom_cto_oss_orgslist_gt;
3657:
3658:
3659: If PG_DEBUG <> 0 Then
3660: If x_oss_orgs_list.line_id.count <> 0 Then

Line 3884: delete from bom_cto_oss_orgslist_gt;

3880: End if;
3881:
3882: END LOOP;
3883:
3884: delete from bom_cto_oss_orgslist_gt;
3885:
3886: l_stmt_no := 30;
3887: update bom_cto_oss_source_gt ossgt1
3888: set reuse_flag = 'N'

Line 3914: INSERT into bom_cto_oss_orgslist_gt(

3910: and ossgt2.valid_flag = 'Y');
3911:
3912:
3913: l_stmt_no := 50;
3914: INSERT into bom_cto_oss_orgslist_gt(
3915: Inventory_item_id,
3916: line_id,
3917: ato_line_id,
3918: organization_id,

Line 4068: INSERT into bom_cto_oss_orgslist_gt(

4064:
4065:
4066:
4067:
4068: INSERT into bom_cto_oss_orgslist_gt(
4069: Inventory_item_id,
4070: line_id,
4071: ato_line_id,
4072: organization_id,

Line 4890: delete /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N1) /

4886: End if;
4887:
4888: l_stmt_num := 20;
4889:
4890: delete /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N1) */
4891: from bom_cto_oss_orgslist_gt oss_lis
4892: where ato_line_id = p_ato_line_id;
4893:
4894: For oss_model_rec in oss_models

Line 4891: from bom_cto_oss_orgslist_gt oss_lis

4887:
4888: l_stmt_num := 20;
4889:
4890: delete /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N1) */
4891: from bom_cto_oss_orgslist_gt oss_lis
4892: where ato_line_id = p_ato_line_id;
4893:
4894: For oss_model_rec in oss_models
4895: Loop

Line 5203: select /+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) /

5199: and config_creation <> '3'
5200: order by plan_level;
5201:
5202: Cursor mfg_orgs_cur(p_line_id Number) is
5203: select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
5204: organization_id
5205: from bom_cto_oss_orgslist_gt oss_lis
5206: where line_id = p_line_id;
5207:

Line 5205: from bom_cto_oss_orgslist_gt oss_lis

5201:
5202: Cursor mfg_orgs_cur(p_line_id Number) is
5203: select /*+ INDEX (oss_lis BOM_CTO_OSS_ORGSLIST_GT_N2) */
5204: organization_id
5205: from bom_cto_oss_orgslist_gt oss_lis
5206: where line_id = p_line_id;
5207:
5208: x_assg_list assg_rec;
5209: l_stmt_num Number;

Line 5225: into bom_cto_oss_orgslist_gt(

5221: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCNIG_DATA: Inside GET_ORDER_SOURCING_DATA API',5);
5222: End if;
5223:
5224: Insert
5225: into bom_cto_oss_orgslist_gt(
5226: line_id,
5227: organization_id,
5228: ato_line_id
5229: )

Line 5616: insert into bom_cto_oss_orgslist_gt(

5612: l_assg_id := src_rec.assignment_id;
5613: If src_rec.source_type in (2,3) Then
5614: l_stmt_num := 50;
5615: oe_debug_pub.add(lpad(' ',g_pg_level)||'TRAVERSE_SOURCING_CHAIN: End org = '||src_rec.organization_id,1);
5616: insert into bom_cto_oss_orgslist_gt(
5617: line_id,
5618: organization_id,
5619: ato_line_id
5620: )

Line 5652: insert into bom_cto_oss_orgslist_gt(

5648: If PG_DEBUG <> 0 Then
5649: oe_debug_pub.add(lpad(' ',g_pg_level)||'TRAVERSE_SOURCING_CHAIN: End of source chain',5);
5650: End if;
5651:
5652: insert into bom_cto_oss_orgslist_gt(
5653: line_id,
5654: organization_id,
5655: ato_line_id
5656: )

Line 5952: from bom_cto_oss_orgslist_gt

5948: organization_id,
5949: vendor_id,
5950: vendor_site_code,
5951: make_flag
5952: from bom_cto_oss_orgslist_gt
5953: where line_id = p_line_id;
5954: begin
5955: oe_debug_pub.add('================PRINTING BOM_CTO_ORGSLIST_GT==================',5);
5956: oe_debug_pub.add('================ Line id = '||p_line_id||'======================',5);