APPS.PO_R12_CAT_UPG_DEF_PVT dependencies on PO_BUYERS_VAL_V

Line 1186: FROM PO_BUYERS_VAL_V VALID_BUYER

1182: --AND x_headers_rec.has_errors(i) = 'N'
1183: AND x_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create
1184: AND EXISTS
1185: (SELECT 'Its a valid buyer'
1186: FROM PO_BUYERS_VAL_V VALID_BUYER
1187: WHERE VALID_BUYER.employee_id = POH.agent_id);
1188:
1189: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;
1190:

Line 1241: FROM PO_BUYERS_VAL_V VALID_BUYER

1237: AND POH.org_id = x_headers_rec.org_id(i)
1238: AND POH.type_lookup_code IN ('BLANKET', 'CONTRACT', 'STANDARD')
1239: AND EXISTS
1240: (SELECT 'Its a valid buyer'
1241: FROM PO_BUYERS_VAL_V VALID_BUYER
1242: WHERE VALID_BUYER.employee_id = POH.agent_id)
1243: ORDER BY
1244: DECODE(POH.type_lookup_code,
1245: 'BLANKET', 1,

Line 1283: -- Note: In this query, we need the sub query because the view PO_BUYERS_VAL_V

1279: -- SQL Why : It will be used to populate the OUT parameters (to default the
1280: -- agent_id into the new GBPA)
1281: -- SQL Join: org_id, business_group_id, agent_id
1282:
1283: -- Note: In this query, we need the sub query because the view PO_BUYERS_VAL_V
1284: -- does not have the column CREATION_DATE, on which we want to sort.
1285: -- Bug#5389286 use PER_EMPLOYEES_CURRENT_X instead of POBUYERS_VAL_V
1286: -- and collapsed 2 subqueries into 1 subquery to get newest valid
1287: -- buyer in the current business group