APPS.CTO_OSS_SOURCE_PK dependencies on MRP_SOURCING_RULES

Line 2491: -- mrp_sourcing_rules_s.nextval

2487: 'CTO*'||bom_Cto_oss_source_rule_s1.nextval,
2488: Sourcing_rule_type,
2489: MRP_Globals.G_OPR_CREATE,
2490: 1
2491: -- mrp_sourcing_rules_s.nextval
2492: Into
2493: l_sourcing_rule_rec.attribute1,
2494: l_sourcing_rule_rec.attribute2,
2495: l_sourcing_rule_rec.attribute3,

Line 2516: From mrp_sourcing_rules

2512: l_sourcing_rule_rec.Sourcing_rule_type,
2513: l_sourcing_rule_rec.Operation,
2514: l_sourcing_rule_rec.status
2515: -- l_sourcing_rule_rec.sourcing_rule_id
2516: From mrp_sourcing_rules
2517: where sourcing_rule_id = source_tree_rec.sourcing_rule_id;
2518:
2519:
2520: If PG_DEBUG <> 0 Then

Line 3009: select mrp_sourcing_rules_s.nextval

3005:
3006: l_sourcing_rule_rec.Sourcing_rule_type := 1;
3007:
3008: /*
3009: select mrp_sourcing_rules_s.nextval
3010: into l_sourcing_rule_rec.sourcing_rule_id
3011: from dual;
3012: */
3013:

Line 5236: mrp_sourcing_rules rule,

5232: from
5233: mrp_sr_receipt_org rcv,
5234: mrp_sr_source_org src,
5235: mrp_sr_assignments assg,
5236: mrp_sourcing_rules rule,
5237: po_vendor_sites_all vend,
5238: bom_cto_order_lines_gt bcol
5239: where
5240: assg.assignment_set_id = g_def_assg_set

Line 5305: mrp_sourcing_rules rule,

5301: from
5302: mrp_sr_receipt_org rcv,
5303: mrp_sr_source_org src,
5304: mrp_sr_assignments assg,
5305: mrp_sourcing_rules rule,
5306: po_vendor_sites_all vend,
5307: bom_cto_order_lines_gt bcol
5308: where
5309: assg.assignment_set_id = g_def_assg_set

Line 5374: mrp_sourcing_rules rule,

5370: from
5371: mrp_sr_receipt_org rcv,
5372: mrp_sr_source_org src,
5373: mrp_sr_assignments assg,
5374: mrp_sourcing_rules rule,
5375: po_vendor_sites_all vend
5376: where
5377: assg.assignment_set_id = g_def_assg_set
5378: and assg.inventory_item_id = p_item_id

Line 5995: mrp_sourcing_rules rule,

5991: from
5992: mrp_sr_receipt_org rcv,
5993: mrp_sr_source_org src,
5994: mrp_sr_assignments assg,
5995: mrp_sourcing_rules rule,
5996: po_vendor_sites_all vend
5997: where
5998: assg.assignment_set_id = g_def_assg_set
5999: and assg.assignment_id = x_assg_list.assignment_id(i)

Line 6060: mrp_sourcing_rules rule,

6056: from
6057: mrp_sr_receipt_org rcv,
6058: mrp_sr_source_org src,
6059: mrp_sr_assignments assg,
6060: mrp_sourcing_rules rule,
6061: po_vendor_sites_all vend,
6062: bom_cto_order_lines_gt bcol
6063: where
6064: assg.assignment_set_id = g_def_assg_set

Line 6147: mrp_sourcing_rules rule,

6143: from
6144: mrp_sr_receipt_org rcv,
6145: mrp_sr_source_org src,
6146: mrp_sr_assignments assg,
6147: mrp_sourcing_rules rule,
6148: po_vendor_sites_all vend,
6149: bom_cto_order_lines_gt bcol
6150: where
6151: assg.assignment_set_id = g_def_assg_set