DBA Data[Home] [Help]

APPS.CTO_OSS_SOURCE_PK dependencies on BOM_CTO_SRC_ORGS

Line 2262: from bom_cto_src_orgs

2258: set valid_flag = 'P'
2259: where line_id = oss_model_lines_rec.line_id
2260: and valid_flag = 'Y'
2261: and rcv_org_id in (select rcv_org_id
2262: from bom_cto_src_orgs
2263: where line_id = oss_model_lines_rec.line_id
2264: and organization_type is not null);
2265: IF PG_DEBUG <> 0 then
2266: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULE: Number of lines updated in bom_cto_oss_source_gt ='

Line 2277: from bom_cto_src_orgs

2273: where line_id = oss_model_lines_rec.line_id
2274: and valid_flag = 'Y'
2275: and rcv_org_id is null
2276: and exists (select rcv_org_id
2277: from bom_cto_src_orgs
2278: where line_id = oss_model_lines_rec.line_id
2279: and organization_type is not null
2280: and rcv_org_id not in (select /*+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N2) */
2281: rcv_org_id