APPS.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_REC_NREC_DIST_GT

Line 6441: UPDATE zx_rec_nrec_dist_gt gt

6437:
6438: -- Bug 11808769,For PO matched invoices, where quantity, price is NULL from purchase order,stamp AMOUNT as value for variance columns
6439: -- ref_per_trx_curr_unit_nr_amt, ref_doc_per_unit_nrec_tax_amt
6440:
6441: UPDATE zx_rec_nrec_dist_gt gt
6442: SET per_trx_curr_unit_nr_amt =
6443: -- Bugfix 5218651: for amount based matching, when dist qty is 0 or null, return rec_nrec_tax_amt as per unit nr amount
6444: DECODE(gt.trx_line_dist_qty*gt.unit_price,0, NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt),
6445: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/(gt.trx_line_dist_qty * gt.unit_price * (1 - (ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100)))),

Line 6485: UPDATE zx_rec_nrec_dist_gt gt

6481: AND mrc_tax_dist_flag = 'N';
6482:
6483: -- update ref_doc_unit_price if it is null (PO has no tax)
6484: --
6485: UPDATE zx_rec_nrec_dist_gt gt
6486: SET ref_doc_unit_price =
6487: (SELECT unit_price
6488: FROM zx_lines_det_factors line
6489: WHERE line.application_id = gt.ref_doc_application_id

Line 6515: UPDATE zx_rec_nrec_dist_gt gt

6511: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.calc_variance_factors',
6512: 'Flow - retainage release invoice');
6513: END IF;
6514:
6515: UPDATE zx_rec_nrec_dist_gt gt
6516: SET per_trx_curr_unit_nr_amt =
6517: -- Bugfix 5218651: for amount based matching, when dist qty is 0 or null, return rec_nrec_tax_amt as per unit nr amount
6518: DECODE(gt.trx_line_dist_qty*gt.unit_price,0, NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt),
6519: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/(gt.trx_line_dist_qty * gt.unit_price * (ZX_TRD_SERVICES_PUB_PKG.g_retained_value/100))),

Line 6559: UPDATE zx_rec_nrec_dist_gt gt

6555: AND mrc_tax_dist_flag = 'N';
6556:
6557: -- update ref_doc_unit_price if it is null (PO has no tax)
6558: --
6559: UPDATE zx_rec_nrec_dist_gt gt
6560: SET ref_doc_unit_price =
6561: (SELECT unit_price
6562: FROM zx_lines_det_factors line
6563: WHERE line.application_id = gt.ref_doc_application_id

Line 6589: UPDATE zx_rec_nrec_dist_gt gt

6585: END IF;
6586:
6587: -- Bug 10069028, As per PM, use unrounded_rec_nrec_tax_amt for variance calculation
6588:
6589: UPDATE zx_rec_nrec_dist_gt gt
6590: SET per_trx_curr_unit_nr_amt =
6591: -- Bugfix 5218651: for amount based matching, when dist qty is 0 or null, return rec_nrec_tax_amt as per unit nr amount
6592: DECODE(gt.trx_line_dist_qty*gt.unit_price,0, NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt),
6593: NVL(gt.unrounded_rec_nrec_tax_amt,gt.rec_nrec_tax_amt)/(gt.trx_line_dist_qty*gt.unit_price)),

Line 6636: UPDATE zx_rec_nrec_dist_gt gt

6632: --
6633: -- Bug 10406032, update ref_per_trx_curr_unit_nr_amt and ref_doc_per_unit_nrec_tax_amt to 0 if PO has no tax.
6634: -- Bug 14648916, update per_trx_curr_unit_nr_amt and per_unit_nrec_tax_amt based on rounded rec_nrec_tax_amt
6635:
6636: UPDATE zx_rec_nrec_dist_gt gt
6637: SET ref_doc_unit_price =
6638: (SELECT unit_price
6639: FROM zx_lines_det_factors line
6640: WHERE line.application_id = gt.ref_doc_application_id