DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on JAI_RCV_RGM_LINES

Line 4440: FROM jai_rcv_rgm_lines

4436:
4437: CURSOR cur_term(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
4438: IS
4439: SELECT term_id, rcv_rgm_line_id, receipt_date
4440: FROM jai_rcv_rgm_lines
4441: WHERE shipment_line_id = cp_shipment_line_id
4442: AND receipt_num=p_receipt_num
4443: and organization_id=p_organization_id
4444: and inventory_item_id=p_inventory_item_id

Line 4640: update jai_rcv_rgm_lines

4636: ln_debit_amt:=nvl(ln_debit_amt,0)+ sch_det.installment_amount;
4637: end if;
4638:
4639: end loop;
4640: update jai_rcv_rgm_lines
4641: set recoverable_amount = nvl(recoverable_amount,0) + nvl(ln_debit_amt,0)
4642: where rcv_rgm_line_id = r_term.rcv_rgm_line_id;
4643:
4644: cgvat_reposit_entry(p_organization_id ,