APPS.CTO_OSS_SOURCE_PK dependencies on BOM_CTO_OSS_ORGS_LIST

Line 993: and exists (select 'x' from bom_cto_oss_orgs_list ossl

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
994: where ossl.oss_comp_seq_id = ossc.oss_comp_seq_id);
995:
996:
997: If PG_DEBUG <> 0 then

Line 1026: bom_cto_oss_orgs_list ossl,

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
1030: ossc.model_item_id = p_model_item_id

Line 1073: bom_cto_oss_orgs_list ossl,

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
1077: bcol.parent_ato_line_id = p_model_line_id

Line 4853: bom_cto_oss_orgs_list ossl

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
4857: and ossl.oss_comp_Seq_id = ossc.oss_comp_seq_id)