[Home] [Help]
86:
87: pv_transaction_source in varchar2,
88: pv_line_type in varchar2,
89: pn_transaction_header_id in number,
90: pn_transaction_dist_id in number, /* One of PO_REQ_DISTRIBUTIONS_ALL.distribution_id, PO_DISTRIBUTIONS_ALL.po_distribution_id, RCV_TRANSACTIONS.transaction_id, AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id */
91: pv_currency_of_return_tax_amt in varchar2 default null, /* no value is passed, then tax amount in transaction currency is returned */
92: pv_transaction_uom in varchar2 default null, /* if not given, then conversion of UOM w.r.to main transaction will not be performed */
93: pn_transaction_qty in number default null,
94: pn_currency_conv_rate in number default null
118: r_get_reqn_line_dtl c_get_reqn_line_dtl%rowtype;
119:
120: cursor c_get_po_dist_dtl(pn_po_dist_id in number) is
121: select line_location_id, quantity_ordered
122: from po_distributions_all
123: where po_distribution_id = pn_po_dist_id;
124: r_get_po_dist_dtl c_get_po_dist_dtl%rowtype;
125:
126: cursor c_get_po_line_loc_dtl(pn_line_loc_id in number) is
1791: SELECT pda.po_distribution_id,
1792: pda.accrue_on_receipt_flag,
1793: aida.project_id
1794: FROM ap_invoices_all aia,
1795: po_distributions_all pda,
1796: ap_invoice_distributions_all aida
1797: WHERE aia.invoice_id = cp_invoice_id
1798: AND aida.invoice_id = aia.invoice_id
1799: AND pda.po_distribution_id = aida.po_distribution_id
1938: from rcv_transactions rcv_txn,
1939: rcv_receiving_sub_ledger rcv_sub,
1940: po_headers_all po_head,
1941: po_lines_all po_line,
1942: po_distributions_all po_dist,
1943: po_vendors vend
1944: where po_dist.CODE_COMBINATION_ID =rcv_sub.CODE_COMBINATION_ID
1945: AND rcv_sub.ACTUAL_FLAG = 'A'
1946: and rcv_sub.pa_addition_flag = 'Y'