APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_OM_OE_RMA_LINES

Line 4874: FROM JAI_OM_OE_RMA_LINES

4870:
4871:
4872: CURSOR SO_RMA_LINES_INFO IS
4873: SELECT tax_category_id, assessable_value, service_type_code
4874: FROM JAI_OM_OE_RMA_LINES
4875: WHERE rma_line_id = v_interface_line_attribute7;
4876:
4877: CURSOR SO_RMA_TAX_LINES_INFO IS
4878: SELECT A.tax_line_no, A.uom, A.tax_id, A.tax_rate, A.qty_rate, A.base_tax_amount, A.tax_amount, b.tax_type,

Line 4898: FROM JAI_OM_OE_RMA_LINES

4894:
4895: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
4896: CURSOR SO_RMA_RECORD_CHECK IS
4897: SELECT 1
4898: FROM JAI_OM_OE_RMA_LINES
4899: WHERE rma_line_id = v_interface_line_attribute7;
4900:
4901:
4902: CURSOR SO_RMA_TAX_RECORD_CHECK IS

Line 4919: FROM JAI_OM_OE_RMA_LINES

4915:
4916:
4917: CURSOR SO_RMA_QUANTITY_CHECK IS
4918: SELECT NVL(quantity,0)
4919: FROM JAI_OM_OE_RMA_LINES
4920: WHERE rma_line_id = v_interface_line_attribute7;
4921:
4922:
4923: cursor c_ont_source_code is

Line 5045: FROM JAI_OM_OE_RMA_LINES

5041:
5042: CURSOR SO_RMA_LINES_INFO IS
5043: --added unit_code,line_amount
5044: SELECT tax_category_id, assessable_value, service_type_code, quantity, inventory_item_id ,uom, selling_price
5045: FROM JAI_OM_OE_RMA_LINES
5046: WHERE rma_line_id = TO_NUMBER(v_interface_line_attribute7);
5047:
5048: CURSOR SO_RMA_TAX_LINES_INFO IS
5049: SELECT A.tax_line_no, A.uom, A.tax_id, A.tax_rate, A.qty_rate, A.base_tax_amount, A.tax_amount, b.tax_type,