APPS.PO_PALT_MS_COMPLETION dependencies on PO_REQUISITION_LINES_ALL

Line 11: FROM PO_REQUISITION_LINES_ALL PRL,

7: BEGIN
8:
9: SELECT DECODE(val,TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'), to_date(NULL), val) INTO L_Solicit_Creation_Dt
10: FROM ( SELECT MAX(NVL(PAIP.CREATION_DATE, TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'))) val
11: FROM PO_REQUISITION_LINES_ALL PRL,
12: PON_BACKING_REQUISITIONS PBR,
13: PON_AUCTION_ITEM_PRICES_ALL PAIP
14: WHERE PRL.REQUISITION_LINE_ID = PBR.REQUISITION_LINE_ID (+)
15: AND NVL(PRL.CLM_INFO_FLAG,'N') <> 'Y'

Line 37: FROM PO_REQUISITION_LINES_ALL PRLA,

33: BEGIN
34:
35: SELECT DECODE(val,TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'), to_date(NULL), val) INTO L_Solicit_Publish_Dt
36: FROM ( SELECT MAX(NVL(PUBLISH_DATE, TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'))) val
37: FROM PO_REQUISITION_LINES_ALL PRLA,
38: PON_BACKING_REQUISITIONS PBR ,
39: PON_AUCTION_HEADERS_ALL PAHA
40: WHERE PRLA.REQUISITION_LINE_ID = PBR.REQUISITION_LINE_ID(+)
41: AND NVL(PRLA.CLM_INFO_FLAG,'N') <> 'Y'

Line 64: FROM PO_REQUISITION_LINES_ALL PRLA,

60:
61: SELECT DECODE(val,TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'), to_date(NULL), val) INTO L_Award_Creation_Dt
62: FROM (
63: SELECT MAX(NVL(PLLA.CREATION_DATE, TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'))) val
64: FROM PO_REQUISITION_LINES_ALL PRLA,
65: PO_REQ_DISTRIBUTIONS_ALL PRD,
66: PO_DISTRIBUTIONS_ALL PD,
67: PO_LINE_LOCATIONS_ALL PLLA
68: WHERE PRD.REQUISITION_LINE_ID=PRLA.REQUISITION_LINE_ID

Line 75: FROM PO_REQUISITION_LINES_ALL PRLA,

71: AND NVL(PRLA.CLM_INFO_FLAG,'N') <> 'Y'
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')

Line 83: FROM PO_REQUISITION_LINES_ALL PRLA,

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
81: UNION
82: SELECT MAX(NVL(PLLDA.CREATION_DATE, TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'))) val
83: FROM PO_REQUISITION_LINES_ALL PRLA,
84: PO_REQ_DISTRIBUTIONS_ALL PRD,
85: PO_DISTRIBUTIONS_DRAFT_ALL PDD,
86: PO_LINE_LOCATIONS_DRAFT_ALL PLLDA
87: WHERE PRD.REQUISITION_LINE_ID=PRLA.REQUISITION_LINE_ID

Line 110: FROM PO_REQUISITION_LINES_ALL PRLA,

106: BEGIN
107:
108: SELECT DECODE(val,TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'), to_date(NULL), val) INTO L_Award_Approval_Dt
109: FROM ( SELECT MAX(NVL(PLLA.APPROVED_DATE, TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'))) val
110: FROM PO_REQUISITION_LINES_ALL PRLA,
111: PO_REQ_DISTRIBUTIONS_ALL PRD,
112: PO_DISTRIBUTIONS_ALL PD,
113: PO_LINE_LOCATIONS_ALL PLLA
114: WHERE PRD.REQUISITION_LINE_ID=PRLA.REQUISITION_LINE_ID