APPS.CTO_OSS_SOURCE_PK dependencies on BOM_CTO_OSS_COMPONENTS

Line 405: from bom_cto_oss_components);

401: select 'Y'
402: into l_oss_defined
403: from dual
404: where exists (select 'x'
405: from bom_cto_oss_components);
406: Exception when no_data_found then
407: l_oss_defined := 'N';
408: end;
409:

Line 988: from bom_cto_oss_components ossc,

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
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

Line 1025: from bom_cto_oss_components ossc,

1021: p_model_item_id inventory_item_id,
1022: ossl.organization_id organization_id,
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

Line 1072: from bom_cto_oss_components ossc,

1068: decode(ossl.vendor_site_code,null,'-1',
1069: ossl.vendor_site_code) vendor_site_code,
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

Line 4065: Will check if there is some record exists in bom_cto_oss_components .

4061: end if;
4062:
4063:
4064: /* Check to see if there is some OSS list specified for any model.
4065: Will check if there is some record exists in bom_cto_oss_components .
4066: If there is no record, then CTO need not do anything. This means the OSS orgs
4067: are not specified by user for any model. The following part of the code will
4068: check this.
4069: */

Line 4079: where exists (select 'x' from bom_cto_oss_components);

4075: Begin
4076: Select 'X'
4077: into l_check_flag
4078: from dual
4079: where exists (select 'x' from bom_cto_oss_components);
4080:
4081: If l_check_flag = 'X' then
4082: If PG_DEBUG <> 0 Then
4083: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_OSS_ORGS_LIST: Some OSS Setup Exists',5);

Line 4260: from bom_cto_oss_components ossc,

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
4263: and ossc.model_item_id = bcol1.inventory_item_id
4264: and ossc.option_item_id = bcol2.inventory_item_id)

Line 4851: from bom_cto_oss_components ossc,

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
4854: where bcol2.parent_ato_line_id = bcol1.line_id
4855: and ossc.model_item_id = bcol1.inventory_item_id