APPS.CTO_OSS_SOURCE_PK dependencies on MTL_SYSTEM_ITEMS

Line 492: from mtl_system_items msi,

488:
489: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
490: option_specific_sourced
491: into l_option_specific
492: from mtl_system_items msi,
493: bom_cto_order_lines_gt bcol
494: where msi.inventory_item_id = bcol.config_item_id
495: and line_id = p_ato_line_id
496: and rownum =1; /* Bugfix 3472654 */

Line 503: mtl_system_items msi

499: select /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */
500: 'Y'
501: into l_valid_ship_from_org
502: from bom_cto_order_lines_gt bcol,
503: mtl_system_items msi
504: where line_id = p_ato_line_id
505: and msi.inventory_item_id = bcol.config_item_id
506: and msi.organization_id = bcol.ship_from_org_id
507: and msi.option_specific_sourced is not null

Line 547: mtl_system_items msi

543: Begin
544: Select 'x'
545: into l_valid_preconfig_org
546: from bom_cto_order_lines_gt bcol,
547: mtl_system_items msi
548: where line_id = p_ato_line_id
549: and msi.inventory_item_id = bcol.config_item_id
550: and msi.organization_id = bcol.ship_from_org_id
551: and msi.option_specific_sourced is not null

Line 607: the matched config with its oss value from mtl_system_items to bcol so that

603:
604: But we don't update the bcol date with the oss flag. As we have not updated
605: the oss flag, later part of the program is copying the sourcing rule from model
606: assuming that this is not a oss config. To avoid this issue, we will flag all
607: the matched config with its oss value from mtl_system_items to bcol so that
608: we won't have this issue.
609:
610: */
611:

Line 615: from mtl_system_items

611:
612: /* Commenting out this update sql as part of bugfix 8894392(FP:7520529).
613: update bom_cto_order_lines_gt bcolgt
614: set option_specific = (select option_specific_sourced
615: from mtl_system_items
616: where inventory_item_id = bcolgt.config_item_id
617: and rownum = 1)
618: where config_item_id is not null
619: and ato_line_id = p_ato_line_id;

Line 680: from mtl_system_items msi

676: if p_mode = 'ACC' then
677: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
678: bom_cto_order_lines_gt bcol
679: set bcol.option_specific = (select msi.option_specific_sourced
680: from mtl_system_items msi
681: where msi.inventory_item_id = bcol.config_item_id
682: and rownum =1)
683: where bcol.perform_match = 'Y' /* We need to add config creation condition here */
684: and bcol.config_creation = '3'

Line 1246: mtl_system_items msi

1242: 2, /* Make at source type */
1243: 'Y', /* Valid flag */
1244: 'Y' /* Leaf node */
1245: from bom_cto_oss_orgslist_gt oss_lis,
1246: mtl_system_items msi
1247: where oss_lis.organization_id not in
1248: (select /*+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N2) */
1249: nvl(rcv_org_id,-1)
1250: from bom_cto_oss_source_gt oss_src

Line 1807: mtl_system_items msi,

1803: 2,
1804: 'Y',
1805: 'Y'
1806: from bom_cto_oss_orgslist_gt oss_lis,
1807: mtl_system_items msi,
1808: bom_cto_order_lines_gt bcol
1809: where
1810: bcol.line_id = p_model_line_id
1811: and bcol.option_specific = '3'

Line 3322: update mtl_system_items msi

3318: End if;
3319:
3320: If p_mode = 'UPG' then
3321:
3322: update mtl_system_items msi
3323: set msi.option_specific_sourced = (select bcol.option_specific
3324: from bom_cto_order_lines_upg bcol
3325: where bcol.ato_line_id= p_ato_line_id
3326: and bcol.config_item_id = msi.inventory_item_id

Line 3338: update mtl_system_items msi

3334: and bom_item_type = 1
3335: and option_specific in ('1','2','3')
3336: );
3337: elsif p_mode = 'ACC' Then
3338: update mtl_system_items msi
3339: set msi.option_specific_sourced = (select bcol.option_specific
3340: from bom_cto_order_lines bcol
3341: where bcol.ato_line_id=p_ato_line_id
3342: and bcol.config_item_id =msi.inventory_item_id

Line 4612: mtl_system_items msi,

4608: from mrp_sr_receipt_org rcv,
4609: mrp_sr_source_org src,
4610: mrp_sr_assignments assg,
4611: bom_cto_order_lines_gt bcol,
4612: mtl_system_items msi,
4613: ap_supplier_sites_all vend
4614:
4615: where
4616: bcol.ato_line_id = bcol.line_id

Line 4646: mtl_system_items msi

4642: null
4643:
4644: from mrp_sr_assignments assg,
4645: bom_cto_order_lines_gt bcol,
4646: mtl_system_items msi
4647:
4648: where
4649: bcol.ato_line_id = bcol.line_id
4650: and nvl(bcol.wip_supply_type,-1)<> 6

Line 4677: mtl_system_items msi,

4673: from mrp_sr_receipt_org rcv,
4674: mrp_sr_source_org src,
4675: mrp_sr_assignments assg,
4676: bom_cto_order_lines_gt bcol,
4677: mtl_system_items msi,
4678: ap_supplier_sites_all vend
4679:
4680: where
4681: bcol.config_item_id is not null

Line 4714: mtl_system_items msi

4710: null
4711:
4712: from mrp_sr_assignments assg,
4713: bom_cto_order_lines_gt bcol,
4714: mtl_system_items msi
4715:
4716: where
4717: bcol.config_item_id is not null
4718: and bcol.top_model_line_id is not null

Line 4961: from mtl_system_items msi

4957: -- parameter in this procedure.
4958: --update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N1) */
4959: /* bom_cto_order_lines_gt bcol
4960: set bcol.option_specific = (select msi.option_specific_sourced
4961: from mtl_system_items msi
4962: where msi.inventory_item_id = bcol.config_item_id
4963: and rownum =1)
4964: where bcol.perform_match = 'Y'*/ /* We need to add config creation condition here */
4965: /*and bcol.config_creation = '3'

Line 6480: from mtl_system_items

6476: If x_t_sourcing_info.source_organization_id.count = 0 Then
6477: x_sourcing_rule_exists := 'N';
6478: Select planning_make_buy_code
6479: into x_source_type
6480: from mtl_system_items
6481: where inventory_item_id = p_inventory_item_id
6482: and organization_id = p_organization_id;
6483: If PG_DEBUG <> 0 Then
6484: oe_debug_pub.add(lpad(' ',g_pg_level)||'QUERY_OSS_SOURCING_ORG: No sourcing rule exists',5);