APPS.PO_REQ_DOCUMENT_UPDATE_PVT dependencies on PO_REQUISITION_LINES

Line 105: FROM po_requisition_lines rl, po_req_distributions rd

101: rd.distribution_id,
102: --ReqDistributionQuantity: prorated from line
103: decode(p_lines.quantity(i), null, null,
104: rd.req_line_quantity * p_lines.quantity(i) / rl.quantity)
105: FROM po_requisition_lines rl, po_req_distributions rd
106: where rl.requisition_line_id = p_lines.req_line_id(i)
107: and rd.requisition_line_id = rl.requisition_line_id;
108:
109: -- For each Req Line, Get

Line 143: FROM po_requisition_lines rl, po_req_distributions rd, po_line_types plt

139: decode(plt.matching_basis, 'AMOUNT',
140: nvl(p_lines.amount(i), rl.amount),
141: nvl(p_lines.unit_price(i), rl.unit_price)
142: * nvl(p_lines.quantity(i), rl.quantity)))
143: FROM po_requisition_lines rl, po_req_distributions rd, po_line_types plt
144: where rl.requisition_line_id = p_lines.req_line_id(i)
145: and rd.requisition_line_id = rl.requisition_line_id
146: and rl.line_type_id = plt.line_type_id
147: and rd.distribution_id = num10)

Line 297: update po_requisition_lines

293:
294: l_progress := '060';
295: --Apply Req Line Changes to Database in Bulk
296: FORALL i IN 1..l_line_count
297: update po_requisition_lines
298: set unit_price=
299: nvl(p_req_changes.line_changes.unit_price(i), unit_price),
300: currency_unit_price=
301: nvl(p_req_changes.line_changes.currency_unit_price(i), currency_unit_price),