APPS.CTO_OSS_SOURCE_PK dependencies on MRP_SOURCING_RULES

Line 2274: -- mrp_sourcing_rules_s.nextval

2270: 'CTO*'||bom_Cto_oss_source_rule_s1.nextval,
2271: Sourcing_rule_type,
2272: MRP_Globals.G_OPR_CREATE,
2273: 1
2274: -- mrp_sourcing_rules_s.nextval
2275: Into
2276: l_sourcing_rule_rec.attribute1,
2277: l_sourcing_rule_rec.attribute2,
2278: l_sourcing_rule_rec.attribute3,

Line 2299: From mrp_sourcing_rules

2295: l_sourcing_rule_rec.Sourcing_rule_type,
2296: l_sourcing_rule_rec.Operation,
2297: l_sourcing_rule_rec.status
2298: -- l_sourcing_rule_rec.sourcing_rule_id
2299: From mrp_sourcing_rules
2300: where sourcing_rule_id = source_tree_rec.sourcing_rule_id;
2301:
2302:
2303: If PG_DEBUG <> 0 Then

Line 2578: select mrp_sourcing_rules_s.nextval

2574:
2575: l_sourcing_rule_rec.Sourcing_rule_type := 1;
2576:
2577: /*
2578: select mrp_sourcing_rules_s.nextval
2579: into l_sourcing_rule_rec.sourcing_rule_id
2580: from dual;
2581: */
2582:

Line 4683: mrp_sourcing_rules rule,

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
4687: assg.assignment_set_id = g_def_assg_set

Line 4750: mrp_sourcing_rules rule,

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
4754: assg.assignment_set_id = g_def_assg_set

Line 4817: mrp_sourcing_rules rule,

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
4821: and assg.inventory_item_id = p_item_id

Line 5330: mrp_sourcing_rules rule,

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
5334: and assg.assignment_id = x_assg_list.assignment_id(i)

Line 5395: mrp_sourcing_rules rule,

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
5399: assg.assignment_set_id = g_def_assg_set

Line 5466: mrp_sourcing_rules rule,

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
5470: assg.assignment_set_id = g_def_assg_set