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
905: and exists (select 'x' from bom_cto_oss_orgs_list ossl
906: where ossl.oss_comp_seq_id = ossc.oss_comp_seq_id);
907:
908:
909: If PG_DEBUG <> 0 then
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
942: ossc.model_item_id = p_model_item_id
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
989: bcol.parent_ato_line_id = p_model_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
4324: and ossc.option_item_id = bcol2.inventory_item_id
4325: and ossl.oss_comp_Seq_id = ossc.oss_comp_seq_id)