DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_RCV_LINE_TAXES

Line 1157: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RCV_LINE_TAXES c

1153: CURSOR Get_Receipt_taxes IS SELECT a.tax_id tax_id_po, a.tax_line_no tax_line_no_po, c.tax_id , c.tax_line_no,
1154: a.precedence_1 p_1, a.precedence_2 p_2, a.precedence_3 p_3, a.precedence_4 p_4, a.precedence_5 p_5,
1155: a.precedence_6 p_6, a.precedence_7 p_7, a.precedence_8 p_8, a.precedence_9 p_9, a.precedence_10 p_10,
1156: c.qty_rate, c.tax_rate, c.tax_amount, c.uom
1157: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RCV_LINE_TAXES c
1158: WHERE c.tax_line_no > nvl(v_tax_line_no,0)
1159: AND a.tax_id = b.tax_id
1160: AND c.tax_id = b.tax_id
1161: AND (c.shipment_line_id,a.line_location_id) = (SELECT shipment_line_id,po_line_location_id