DBA Data[Home] [Help]

APPS.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_REC_NREC_DIST_GT

Line 5696: UPDATE zx_rec_nrec_dist_gt gt

5692:
5693: -- Bugfix 5035461: added recoverable_flag and reverse_flag condition in
5694: -- the subquery.
5695:
5696: UPDATE zx_rec_nrec_dist_gt gt
5697: SET per_trx_curr_unit_nr_amt =
5698: -- Bugfix 5218651: for amount based matching, when dist qty is 0 or null, return rec_nrec_tax_amt as per unit nr amount
5699: DECODE(gt.trx_line_dist_qty*gt.unit_price,0, gt.rec_nrec_tax_amt,
5700: gt.rec_nrec_tax_amt/(gt.trx_line_dist_qty*gt.unit_price)),

Line 5739: UPDATE zx_rec_nrec_dist_gt gt

5735: AND mrc_tax_dist_flag = 'N';
5736:
5737: -- update ref_doc_unit_price if it is null (PO has no tax)
5738: --
5739: UPDATE zx_rec_nrec_dist_gt gt
5740: SET ref_doc_unit_price =
5741: (SELECT unit_price
5742: FROM zx_lines_det_factors line
5743: WHERE line.application_id = gt.ref_doc_application_id