APPS.MRP_SOURCING_RULE_PVT dependencies on MRP_CUST_SUP_ORG_V

Line 1294: mrp_cust_sup_org_v are varchar2 */

1290: l_organization_id := FND_API.G_MISS_NUM;
1291:
1292: /* 2448893 - Add to_char to the vendor_id and vendor_site_id in
1293: l_shipping_org_rec since supplier_id and supplier_site_id in
1294: mrp_cust_sup_org_v are varchar2 */
1295:
1296: BEGIN
1297: SELECT organization_id
1298: INTO l_organization_id

Line 1299: FROM mrp_cust_sup_org_v

1295:
1296: BEGIN
1297: SELECT organization_id
1298: INTO l_organization_id
1299: FROM mrp_cust_sup_org_v
1300: WHERE supplier_id = to_char(l_Shipping_Org_rec.vendor_id)
1301: AND supplier_site_id = to_char(l_Shipping_Org_rec.vendor_site_id);
1302:
1303: IF l_organization_id IS NOT NULL AND