DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on JAI_RCV_LINES

Line 3565: SELECT * from jai_rcv_lines

3561: p_shipment_line_id IN NUMBER ,
3562: p_applied_quantity IN NUMBER
3563: ) IS
3564: CURSOR c_rcpt_dtls(cp_shipment_line_id IN NUMBER) Is
3565: SELECT * from jai_rcv_lines
3566: WHERE shipment_line_id = cp_shipment_line_id;
3567:
3568: CURSOR c_recpt_tax_dtls(cp_shipment_line_id IN NUMBER) IS
3569: SELECT * from JAI_RCV_LINE_TAXES

Line 4378: FROM jai_rcv_lines

4374: CURSOR cur_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
4375: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
4376: IS
4377: SELECT shipment_header_id, shipment_line_id
4378: FROM jai_rcv_lines
4379: WHERE shipment_header_id = NVL(cp_shipment_header_id, shipment_header_id)
4380: AND shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
4381: AND receipt_num=p_receipt_num
4382: and organization_id=p_organization_id

Line 4426: jai_rcv_lines c

4422: NVL(b.rounding_factor,0) rounding_factor,
4423: c.qty_received
4424: FROM JAI_RCV_LINE_TAXES a,
4425: jai_cmn_taxes_all b,
4426: jai_rcv_lines c
4427: WHERE a.shipment_line_id =c.shipment_line_id
4428: AND a.shipment_line_id = cp_shipment_line_id
4429: AND a.tax_type IN ( select tax_type
4430: from jai_regime_tax_types_v