APPS.PO_VAL_LINES dependencies on PO_ASL_ATTRIBUTES

Line 1015: , PO_ASL_ATTRIBUTES PAA

1011: , TO_CHAR(p_item_id_tbl(i))
1012: , PO_MESSAGE_S.PO_VMI_ASL_EXIST
1013: FROM
1014: PO_APPROVED_SUPPLIER_LIS_VAL_V PASL
1015: , PO_ASL_ATTRIBUTES PAA
1016: , PO_ASL_STATUS_RULES_V PASR
1017: WHERE
1018: -- item is not null
1019: p_item_id_tbl(i) IS NOT NULL

Line 1035: FROM po_asl_attributes paa2

1031: AND pasr.allow_action_flag = 'Y'
1032: AND pasr.status_id = pasl.asl_status_id
1033: AND paa.using_organization_id =
1034: (SELECT max(paa2.using_organization_id)
1035: FROM po_asl_attributes paa2
1036: WHERE paa2.asl_id = pasl.asl_id
1037: AND paa2.using_organization_id IN (-1, p_org_id_tbl(i)));
1038:
1039: IF (SQL%ROWCOUNT > 0) THEN