eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_OSS_SOURCE_PK dependencies on MRP_SR_ASSIGNMENTS

Line 469: from mrp_sr_assignments assg,

465: and msi.organization_id = bcol.ship_from_org_id
466: and msi.option_specific_sourced is not null
467: and bcol.ship_from_org_id in
468: (select assg.organization_id
469: from mrp_sr_assignments assg,
470: mrp_sr_receipt_org rcv,
471: mrp_sr_source_org src
472: where assg.inventory_item_id = bcol.config_item_id
473: and assg.sourcing_rule_id = rcv.sourcing_rule_id

Line 479: from mrp_sr_assignments assg,

475: and nvl(rcv.disable_date,sysdate+1)>sysdate
476: and rcv.SR_RECEIPT_ID = src.sr_receipt_id
477: union
478: select src.source_organization_id
479: from mrp_sr_assignments assg,
480: mrp_sr_receipt_org rcv,
481: mrp_sr_source_org src
482: where assg.inventory_item_id = bcol.config_item_id
483: and assg.sourcing_rule_id = rcv.sourcing_rule_id

Line 513: from mrp_sr_assignments assg,

509: and msi.organization_id = bcol.ship_from_org_id
510: and msi.option_specific_sourced is not null
511: and bcol.ship_from_org_id in
512: (select assg.organization_id org_id
513: from mrp_sr_assignments assg,
514: mrp_sr_receipt_org rcv,
515: mrp_sr_source_org src
516: where assg.inventory_item_id = bcol.config_item_id
517: and assg.sourcing_rule_id = rcv.sourcing_rule_id

Line 524: from mrp_sr_assignments assg,

520: and rcv.SR_RECEIPT_ID = src.sr_receipt_id
521: and src.source_type in (2,3)
522: union
523: select src.source_organization_id org_id
524: from mrp_sr_assignments assg,
525: mrp_sr_receipt_org rcv,
526: mrp_sr_source_org src
527: where assg.inventory_item_id = bcol.config_item_id
528: and assg.sourcing_rule_id = rcv.sourcing_rule_id

Line 534: from mrp_sr_assignments assg,

530: and nvl(rcv.disable_date,sysdate+1)>sysdate
531: and rcv.SR_RECEIPT_ID = src.sr_receipt_id
532: and src.source_organization_id not in
533: (Select assg.organization_id
534: from mrp_sr_assignments assg,
535: mrp_sr_receipt_org rcv,
536: mrp_sr_source_org src
537: Where assg.inventory_item_id = bcol.config_item_id
538: and assg.sourcing_rule_id = rcv.sourcing_rule_id

Line 1848: mrp_sr_assignments src_asg

1844: src_asg.ship_to_site_id ship_to_site_id,
1845: src_asg.sourcing_rule_type sourcing_rule_type,
1846: src_asg.sourcing_rule_id sourcing_rule_id
1847: from bom_cto_oss_source_gt oss_src,
1848: mrp_sr_assignments src_asg
1849: where oss_src.line_id = p_line_id
1850: and nvl(oss_src.reuse_flag,'Y') = 'N'
1851: and valid_flag = 'P'
1852: and src_asg.assignment_id = oss_src.assignment_id

Line 1854: from mrp_sr_assignments src_asg1

1850: and nvl(oss_src.reuse_flag,'Y') = 'N'
1851: and valid_flag = 'P'
1852: and src_asg.assignment_id = oss_src.assignment_id
1853: and nvl(src_asg.organization_id,-1) not in (select nvl(organization_id,-1)
1854: from mrp_sr_assignments src_asg1
1855: where inventory_item_id = p_config_item_id
1856: and assignment_set_id = G_def_assg_set)
1857:
1858:

Line 1882: from mrp_sr_assignments

1878: and valid_flag = 'P'
1879: and leaf_node = 'Y'
1880: and assignment_id is null
1881: and nvl(rcv_org_id,-1) not in (select nvl(organization_id,-1)
1882: from mrp_sr_assignments
1883: where inventory_item_id = p_config_item_id
1884: and assignment_set_id = G_def_assg_set);
1885: /* This will pick up all rows that we introduced
1886: for 100% make at rule*/

Line 1896: from mrp_sr_assignments

1892: where line_id = p_line_id
1893: and valid_flag = 'P'
1894: and nvl(reuse_flag,'Y') = 'Y'
1895: and nvl(rcv_org_id,-1) not in (select nvl(organization_id,-1)
1896: from mrp_sr_assignments
1897: where inventory_item_id = p_config_item_id
1898: and assignment_set_id = G_def_assg_set);
1899:
1900: l_temp_count Number;

Line 2695: -- a full table scan on MRP_SR_ASSIGNMENTS and consequent

2691: --
2692: -- bug 6617686
2693: -- The MRP API uses a ASSIGNMENT_ID = p_Assignment_Id OR
2694: -- ASSIGNMENT_SET_ID = p_Assignment_Set_Id that leads to
2695: -- a full table scan on MRP_SR_ASSIGNMENTS and consequent
2696: -- performance issues. Since CTO does not pass ASSIGNMENT_SET_ID
2697: -- into the procedure, it is performance effective to directly
2698: -- query the MRP table
2699: -- ntungare

Line 2777: FROM MRP_SR_ASSIGNMENTS

2773: , lAssignmentRec.SECONDARY_INVENTORY
2774: , lAssignmentRec.SHIP_TO_SITE_ID
2775: , lAssignmentRec.SOURCING_RULE_ID
2776: , lAssignmentRec.SOURCING_RULE_TYPE
2777: FROM MRP_SR_ASSIGNMENTS
2778: WHERE ASSIGNMENT_ID = oss_reused_assg_rec.assignment_id;
2779:
2780: If PG_DEBUG <> 0 Then
2781: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: Loading the assignment into assignment record ',5);

Line 4086: mrp_sr_assignments assg,

4082: vend.VENDOR_SITE_CODE
4083:
4084: from mrp_sr_receipt_org rcv,
4085: mrp_sr_source_org src,
4086: mrp_sr_assignments assg,
4087: bom_cto_order_lines_gt bcol,
4088: mtl_system_items msi,
4089: ap_supplier_sites_all vend
4090:

Line 4107: from mrp_sr_assignments

4103: and nvl(rcv.disable_date,sysdate+1)>sysdate
4104: and rcv.SR_RECEIPT_ID = src.sr_receipt_id
4105: and src.vendor_site_id = vend.vendor_site_id(+)
4106: and not exists (select 'X'
4107: from mrp_sr_assignments
4108: where inventory_item_id = bcol.config_item_id
4109: and organization_id is null
4110: and msi.option_specific_sourced = 3)
4111: UNION

Line 4120: from mrp_sr_assignments assg,

4116: assg.organization_id,
4117: to_number(null), --3894241
4118: null
4119:
4120: from mrp_sr_assignments assg,
4121: bom_cto_order_lines_gt bcol,
4122: mtl_system_items msi
4123:
4124: where

Line 4135: from mrp_sr_assignments

4131: and assg.assignment_set_id = p_assignment_id
4132: and assg.customer_id is null
4133: and assg.inventory_item_id = msi.inventory_item_id
4134: and not exists (select 'X'
4135: from mrp_sr_assignments
4136: where inventory_item_id = bcol.config_item_id
4137: and organization_id is null
4138: and msi.option_specific_sourced = 3)
4139:

Line 4151: mrp_sr_assignments assg,

4147: vend.VENDOR_SITE_CODE
4148:
4149: from mrp_sr_receipt_org rcv,
4150: mrp_sr_source_org src,
4151: mrp_sr_assignments assg,
4152: bom_cto_order_lines_gt bcol,
4153: mtl_system_items msi,
4154: ap_supplier_sites_all vend
4155:

Line 4174: from mrp_sr_assignments

4170: and nvl(rcv.disable_date,sysdate+1)>sysdate
4171: and rcv.SR_RECEIPT_ID = src.sr_receipt_id
4172: and src.vendor_site_id = vend.vendor_site_id(+)
4173: and not exists (select 'X'
4174: from mrp_sr_assignments
4175: where inventory_item_id = bcol.config_item_id
4176: and organization_id is null
4177: and msi.option_specific_sourced = 3)
4178:

Line 4188: from mrp_sr_assignments assg,

4184: assg.organization_id,
4185: to_number(null),--bugfix3894241
4186: null
4187:
4188: from mrp_sr_assignments assg,
4189: bom_cto_order_lines_gt bcol,
4190: mtl_system_items msi
4191:
4192: where

Line 4206: from mrp_sr_assignments

4202: and assg.assignment_set_id = p_assignment_id
4203: and assg.customer_id is null
4204: and assg.inventory_item_id = msi.inventory_item_id
4205: and not exists (select 'X'
4206: from mrp_sr_assignments
4207: where inventory_item_id = bcol.config_item_id
4208: and organization_id is null
4209: and msi.option_specific_sourced = 3);
4210:

Line 4682: mrp_sr_assignments assg,

4678:
4679: from
4680: mrp_sr_receipt_org rcv,
4681: mrp_sr_source_org src,
4682: mrp_sr_assignments assg,
4683: mrp_sourcing_rules rule,
4684: po_vendor_sites_all vend,
4685: bom_cto_order_lines_gt bcol
4686: where

Line 4749: mrp_sr_assignments assg,

4745:
4746: from
4747: mrp_sr_receipt_org rcv,
4748: mrp_sr_source_org src,
4749: mrp_sr_assignments assg,
4750: mrp_sourcing_rules rule,
4751: po_vendor_sites_all vend,
4752: bom_cto_order_lines_gt bcol
4753: where

Line 4816: mrp_sr_assignments assg,

4812:
4813: from
4814: mrp_sr_receipt_org rcv,
4815: mrp_sr_source_org src,
4816: mrp_sr_assignments assg,
4817: mrp_sourcing_rules rule,
4818: po_vendor_sites_all vend
4819: where
4820: assg.assignment_set_id = g_def_assg_set

Line 5329: mrp_sr_assignments assg,

5325:
5326: from
5327: mrp_sr_receipt_org rcv,
5328: mrp_sr_source_org src,
5329: mrp_sr_assignments assg,
5330: mrp_sourcing_rules rule,
5331: po_vendor_sites_all vend
5332: where
5333: assg.assignment_set_id = g_def_assg_set

Line 5394: mrp_sr_assignments assg,

5390:
5391: from
5392: mrp_sr_receipt_org rcv,
5393: mrp_sr_source_org src,
5394: mrp_sr_assignments assg,
5395: mrp_sourcing_rules rule,
5396: po_vendor_sites_all vend,
5397: bom_cto_order_lines_gt bcol
5398: where

Line 5465: mrp_sr_assignments assg,

5461:
5462: from
5463: mrp_sr_receipt_org rcv,
5464: mrp_sr_source_org src,
5465: mrp_sr_assignments assg,
5466: mrp_sourcing_rules rule,
5467: po_vendor_sites_all vend,
5468: bom_cto_order_lines_gt bcol
5469: where