eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CALCULATEREQTOTAL_PVT dependencies on PO_CHANGE_REQUESTS

Line 11: from po_change_requests if any changes were made

7: * Requisition Line Id
8: * Requisition Distribution Id
9: * Modifies: None.
10: * Effects: Return updated distribution qty X new price
11: from po_change_requests if any changes were made
12: * Else return req_line_quantity X unit price
13: * from po_req_distributions and po_requisition_lines
14: * If line was cancelled return 0
15: * Returns:

Line 25: l_action_type po_change_requests.action_type%type;

21: p_distribution_id IN NUMBER)
22: RETURN NUMBER
23: IS
24: l_matching_basis po_requisition_lines_all.matching_basis%type;
25: l_action_type po_change_requests.action_type%type;
26: l_dist_total NUMBER := 0;
27: l_change_request_group_id po_change_requests.change_request_group_id%type;
28: BEGIN
29:

Line 27: l_change_request_group_id po_change_requests.change_request_group_id%type;

23: IS
24: l_matching_basis po_requisition_lines_all.matching_basis%type;
25: l_action_type po_change_requests.action_type%type;
26: l_dist_total NUMBER := 0;
27: l_change_request_group_id po_change_requests.change_request_group_id%type;
28: BEGIN
29:
30: SELECT prl.matching_basis, pcr.action_type,
31: decode (prl.matching_basis, 'AMOUNT' , prd.req_line_amount,

Line 39: po_change_requests pcr

35: INTO l_matching_basis, l_action_type, l_dist_total,
36: l_change_request_group_id
37: FROM po_requisition_lines_all prl,
38: po_req_distributions_all prd,
39: po_change_requests pcr
40: WHERE prl.requisition_line_id = p_line_id
41: AND prl.requisition_line_id = prd.requisition_line_id
42: AND prd.distribution_id = p_distribution_id
43: AND nvl(prl.cancel_flag,'N') = 'N'

Line 69: from po_change_requests table. This is required as these records causing

65: -- Bug 16168687 start
66:
67: /* The following function is same as get_req_distribution_total except that
68: query for getting dist total is modified to exclude SYSTEMSAVE records
69: from po_change_requests table. This is required as these records causing
70: issue in approving the requisition. Creating new function as existing
71: function is required in AME where SYSTEMSAVE records also needs to be
72: considered.*/
73:

Line 81: from po_change_requests if any changes were made

77: * Requisition Line Id
78: * Requisition Distribution Id
79: * Modifies: None.
80: * Effects: Return updated distribution qty X new price
81: from po_change_requests if any changes were made
82: * Else return req_line_quantity X unit price
83: * from po_req_distributions and po_requisition_lines
84: * If line was cancelled return 0
85: * Returns:

Line 95: l_action_type po_change_requests.action_type%type;

91: p_distribution_id IN NUMBER)
92: RETURN NUMBER
93: IS
94: l_matching_basis po_requisition_lines_all.matching_basis%type;
95: l_action_type po_change_requests.action_type%type;
96: l_dist_total NUMBER := 0;
97: l_change_request_group_id po_change_requests.change_request_group_id%type;
98: BEGIN
99:

Line 97: l_change_request_group_id po_change_requests.change_request_group_id%type;

93: IS
94: l_matching_basis po_requisition_lines_all.matching_basis%type;
95: l_action_type po_change_requests.action_type%type;
96: l_dist_total NUMBER := 0;
97: l_change_request_group_id po_change_requests.change_request_group_id%type;
98: BEGIN
99:
100: SELECT prl.matching_basis, pcr.action_type,
101: decode (prl.matching_basis, 'AMOUNT' , prd.req_line_amount,

Line 109: po_change_requests pcr

105: INTO l_matching_basis, l_action_type, l_dist_total,
106: l_change_request_group_id
107: FROM po_requisition_lines_all prl,
108: po_req_distributions_all prd,
109: po_change_requests pcr
110: WHERE prl.requisition_line_id = p_line_id
111: AND prl.requisition_line_id = prd.requisition_line_id
112: AND prd.distribution_id = p_distribution_id
113: AND nvl(prl.cancel_flag,'N') = 'N'

Line 170: FROM po_change_requests pcr,

166: SELECT prd.req_line_amount,
167: nvl(pcr.new_amount, prd.req_line_amount),
168: prd.nonrecoverable_tax
169: INTO l_old_dist_total, l_new_dist_total, l_nonrec_tax
170: FROM po_change_requests pcr,
171: po_req_distributions_all prd
172: WHERE prd.distribution_id = p_distribution_id
173: AND pcr.document_line_id(+) = prd.requisition_line_id
174: AND pcr.document_distribution_id(+) = prd.distribution_id

Line 184: FROM po_change_requests pcr,

180: SELECT prd.req_line_quantity*prl.unit_price,
181: nvl(pcr1.new_quantity, prd.req_line_quantity)*nvl(pcr.new_price, prl.unit_price),
182: prd.nonrecoverable_tax
183: INTO l_old_dist_total, l_new_dist_total, l_nonrec_tax
184: FROM po_change_requests pcr,
185: po_change_requests pcr1,
186: po_requisition_lines_all prl,
187: po_req_distributions_all prd
188: WHERE prd.distribution_id = p_distribution_id

Line 185: po_change_requests pcr1,

181: nvl(pcr1.new_quantity, prd.req_line_quantity)*nvl(pcr.new_price, prl.unit_price),
182: prd.nonrecoverable_tax
183: INTO l_old_dist_total, l_new_dist_total, l_nonrec_tax
184: FROM po_change_requests pcr,
185: po_change_requests pcr1,
186: po_requisition_lines_all prl,
187: po_req_distributions_all prd
188: WHERE prd.distribution_id = p_distribution_id
189: AND pcr1.document_distribution_id(+) = prd.distribution_id