DBA Data[Home] [Help]

APPS.RCV_PROJECT_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 99: PO_DISTRIBUTIONS_ALL pd,

95: pde.SEGMENT1
96: INTO
97: g_project_number
98: FROM
99: PO_DISTRIBUTIONS_ALL pd,
100: PA_PROJECTS_ALL pde
101: WHERE
102: pd.PO_DISTRIBUTION_ID = l_distribution_id
103: AND pde.PROJECT_ID = pd.PROJECT_ID;

Line 115: PO_DISTRIBUTIONS_ALL pd,

111: pte.TASK_NUMBER
112: INTO
113: g_task_number
114: FROM
115: PO_DISTRIBUTIONS_ALL pd,
116: PA_TASKS pte
117: WHERE
118: pd.PO_DISTRIBUTION_ID = l_distribution_id
119: AND pte.TASK_ID = pd.TASK_ID;

Line 141: PO_DISTRIBUTIONS_ALL pd,

137: DISTINCT(pde.SEGMENT1)
138: INTO
139: g_project_number
140: FROM
141: PO_DISTRIBUTIONS_ALL pd,
142: PA_PROJECTS_ALL pde
143: WHERE
144: pd.LINE_LOCATION_ID = l_line_location_id
145: AND pde.PROJECT_ID = pd.PROJECT_ID;

Line 160: PO_DISTRIBUTIONS_ALL pd,

156: DISTINCT(pte.TASK_NUMBER)
157: INTO
158: g_task_number
159: FROM
160: PO_DISTRIBUTIONS_ALL pd,
161: PA_TASKS pte
162: WHERE
163: pd.LINE_LOCATION_ID = l_line_location_id
164: AND pte.TASK_ID = pd.TASK_ID;