APPS.CTO_OSS_SOURCE_PK dependencies on BOM_CTO_OSS_COMPONENTS

Line 380: from bom_cto_oss_components);

376: select 'Y'
377: into l_oss_defined
378: from dual
379: where exists (select 'x'
380: from bom_cto_oss_components);
381: Exception when no_data_found then
382: l_oss_defined := 'N';
383: end;
384:

Line 900: from bom_cto_oss_components ossc,

896:
897: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N3) */
898: count(*)
899: into l_comp_count
900: from bom_cto_oss_components ossc,
901: bom_cto_order_lines_gt bcol
902: where ossc.model_item_id = p_model_item_id
903: and ossc.option_item_id = bcol.inventory_item_id
904: and bcol.parent_ato_line_id = p_model_line_id

Line 937: from bom_cto_oss_components ossc,

933: p_model_item_id inventory_item_id,
934: ossl.organization_id organization_id,
935: p_ato_line_id
936:
937: from bom_cto_oss_components ossc,
938: bom_cto_oss_orgs_list ossl,
939: bom_cto_order_lines_gt bcol
940:
941: where

Line 984: from bom_cto_oss_components ossc,

980: decode(ossl.vendor_site_code,null,'-1',
981: ossl.vendor_site_code) vendor_site_code,
982: p_ato_line_id ato_line_id
983:
984: from bom_cto_oss_components ossc,
985: bom_cto_oss_orgs_list ossl,
986: bom_cto_order_lines_gt bcol
987:
988: where

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

3542: end if;
3543:
3544:
3545: /* Check to see if there is some OSS list specified for any model.
3546: Will check if there is some record exists in bom_cto_oss_components .
3547: If there is no record, then CTO need not do anything. This means the OSS orgs
3548: are not specified by user for any model. The following part of the code will
3549: check this.
3550: */

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

3556: Begin
3557: Select 'X'
3558: into l_check_flag
3559: from dual
3560: where exists (select 'x' from bom_cto_oss_components);
3561:
3562: If l_check_flag = 'X' then
3563: If PG_DEBUG <> 0 Then
3564: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_OSS_ORGS_LIST: Some OSS Setup Exists',5);

Line 3741: from bom_cto_oss_components ossc,

3737: distinct bcol1.ato_line_id
3738: from bom_cto_order_lines_gt bcol1
3739: where exists (select /*+ INDEX (bcol1 BOM_CTO_ORDER_LINES_GT_N3) */
3740: 'X'
3741: from bom_cto_oss_components ossc,
3742: bom_cto_order_lines_gt bcol2
3743: where bcol2.parent_ato_line_id = bcol1.line_id
3744: and ossc.model_item_id = bcol1.inventory_item_id
3745: and ossc.option_item_id = bcol2.inventory_item_id)

Line 4319: from bom_cto_oss_components ossc,

4315: where
4316: ato_line_id = p_ato_line_id
4317: and exists (select /*+ INDEX (bcol2 BOM_CTO_ORDER_LINES_GT_N3) */
4318: 'X'
4319: from bom_cto_oss_components ossc,
4320: bom_cto_order_lines_gt bcol2,
4321: bom_cto_oss_orgs_list ossl
4322: where bcol2.parent_ato_line_id = bcol1.line_id
4323: and ossc.model_item_id = bcol1.inventory_item_id