APPS.PO_VAL_LINES dependencies on PO_ASL_ATTRIBUTES

Line 1279: , PO_ASL_ATTRIBUTES PAA

1275: , TO_CHAR(p_item_id_tbl(i))
1276: , PO_MESSAGE_S.PO_VMI_ASL_EXIST
1277: FROM
1278: PO_APPROVED_SUPPLIER_LIS_VAL_V PASL
1279: , PO_ASL_ATTRIBUTES PAA
1280: , PO_ASL_STATUS_RULES_V PASR
1281: WHERE
1282: -- item is not null
1283: p_item_id_tbl(i) IS NOT NULL

Line 1299: FROM po_asl_attributes paa2

1295: AND pasr.allow_action_flag = 'Y'
1296: AND pasr.status_id = pasl.asl_status_id
1297: AND paa.using_organization_id =
1298: (SELECT max(paa2.using_organization_id)
1299: FROM po_asl_attributes paa2
1300: WHERE paa2.asl_id = pasl.asl_id
1301: AND paa2.using_organization_id IN (-1, p_org_id_tbl(i)));
1302:
1303: IF (SQL%ROWCOUNT > 0) THEN