DBA Data[Home] [Help]

APPS.PO_PALT_MS_COMPLETION dependencies on PO_LINES_ALL

Line 76: PO_LINES_ALL PLL

72: AND PRLA.ASSIGNMENT_NUMBER = pAssignment_Number
73: UNION
74: SELECT MAX(NVL(PLL.CREATION_DATE, TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'))) val
75: FROM PO_REQUISITION_LINES_ALL PRLA,
76: PO_LINES_ALL PLL
77: WHERE PRLA.PO_LINE_ID = PLL.PO_LINE_ID(+)
78: AND NVL(PRLA.CLM_INFO_FLAG,'N') <> 'Y'
79: AND ((nvl(PRLA.CLM_OPTION_INDICATOR,'N')='O' and nvl(PRLA.CLM_OPTION_EXERCISED,'N')='N') OR nvl(PRLA.FUND_SOURCE_NOT_KNOWN,'N')='Y')
80: AND PRLA.ASSIGNMENT_NUMBER = pAssignment_Number