APPS.JAI_MTL_TRXS_PKG dependencies on JAI_RCV_LINES

Line 3729: SELECT * from jai_rcv_lines

3725: p_shipment_line_id IN NUMBER ,
3726: p_applied_quantity IN NUMBER
3727: ) IS
3728: CURSOR c_rcpt_dtls(cp_shipment_line_id IN NUMBER) Is
3729: SELECT * from jai_rcv_lines
3730: WHERE shipment_line_id = cp_shipment_line_id;
3731:
3732: CURSOR c_recpt_tax_dtls(cp_shipment_line_id IN NUMBER) IS
3733: SELECT * from JAI_RCV_LINE_TAXES

Line 4823: FROM jai_rcv_lines

4819: CURSOR cur_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
4820: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
4821: IS
4822: SELECT shipment_header_id, shipment_line_id
4823: FROM jai_rcv_lines
4824: WHERE shipment_header_id = NVL(cp_shipment_header_id, shipment_header_id)
4825: AND shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
4826: AND receipt_num=p_receipt_num
4827: and organization_id=p_organization_id

Line 4868: jai_rcv_lines c

4864: NVL(b.rounding_factor,0) rounding_factor,
4865: c.qty_received
4866: FROM JAI_RCV_LINE_TAXES a,
4867: jai_cmn_taxes_all b,
4868: jai_rcv_lines c
4869: WHERE a.shipment_line_id =c.shipment_line_id
4870: AND a.shipment_line_id = cp_shipment_line_id
4871: AND a.tax_type IN ( select tax_type
4872: from jai_regime_tax_types_v