eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OM_TAX_PROCESSING_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 75: from JAI_CMN_INVENTORY_ORGS

71: organization_id = v_organization_id;
72:
73: cursor c_orgn_Null_site_info is
74: select exc_shpt_wo_exc_tax_flag
75: from JAI_CMN_INVENTORY_ORGS
76: where organization_id = p_rec_new.ship_from_org_id
77: and location_id = 0;
78:
79: CURSOR Trading_register_code_cur(p_organization_id NUMBER ,

Line 1234: FROM JAI_CMN_INVENTORY_ORGS

1230: sales_return_days,
1231: vat_return_days,
1232: nvl(manufacturing, 'N') manufacturing,
1233: nvl(trading, 'N') trading
1234: FROM JAI_CMN_INVENTORY_ORGS
1235: WHERE organization_id = pr_order_line.ship_from_org_id
1236: AND location_id = 0;
1237:
1238: CURSOR c_ordered_date IS

Line 1316: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;

1312: lv_check_vat_type_exists VARCHAR2(1);
1313: v_date_ordered DATE;
1314: v_date_confirmed DATE;
1315: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1316: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1317: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1318: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1319: v_excise_flag VARCHAR2(1);
1320: v_sales_flag VARCHAR2(1);

Line 1317: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;

1313: v_date_ordered DATE;
1314: v_date_confirmed DATE;
1315: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1316: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1317: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1318: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1319: v_excise_flag VARCHAR2(1);
1320: v_sales_flag VARCHAR2(1);
1321: v_vat_flag VARCHAR2(1);

Line 1318: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;

1314: v_date_confirmed DATE;
1315: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1316: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1317: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1318: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1319: v_excise_flag VARCHAR2(1);
1320: v_sales_flag VARCHAR2(1);
1321: v_vat_flag VARCHAR2(1);
1322: v_round_tax NUMBER;

Line 1326: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;

1322: v_round_tax NUMBER;
1323: v_round_base NUMBER;
1324: v_round_func NUMBER;
1325: v_tax_total NUMBER;
1326: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
1327: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
1328: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
1329: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
1330: v_requested_quantity_uom VARCHAR2(3);

Line 1327: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;

1323: v_round_base NUMBER;
1324: v_round_func NUMBER;
1325: v_tax_total NUMBER;
1326: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
1327: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
1328: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
1329: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
1330: v_requested_quantity_uom VARCHAR2(3);
1331: v_conversion_rate NUMBER := 0;

Line 1990: FROM JAI_CMN_INVENTORY_ORGS

1986: sales_return_days,
1987: vat_return_days,
1988: nvl(manufacturing, 'N') manufacturing,
1989: nvl(trading, 'N') trading
1990: FROM JAI_CMN_INVENTORY_ORGS
1991: WHERE organization_id = pr_order_line.ship_from_org_id
1992: AND location_id = 0;
1993:
1994: CURSOR c_ordered_date IS

Line 2020: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;

2016: lv_check_vat_type_exists VARCHAR2(1);
2017: v_date_ordered DATE;
2018: v_date_confirmed DATE;
2019: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
2020: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
2021: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
2022: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
2023: v_excise_flag VARCHAR2(1);
2024: v_sales_flag VARCHAR2(1);

Line 2021: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;

2017: v_date_ordered DATE;
2018: v_date_confirmed DATE;
2019: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
2020: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
2021: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
2022: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
2023: v_excise_flag VARCHAR2(1);
2024: v_sales_flag VARCHAR2(1);
2025: v_vat_flag VARCHAR2(1);

Line 2022: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;

2018: v_date_confirmed DATE;
2019: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
2020: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
2021: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
2022: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
2023: v_excise_flag VARCHAR2(1);
2024: v_sales_flag VARCHAR2(1);
2025: v_vat_flag VARCHAR2(1);
2026: v_round_tax NUMBER;

Line 2030: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;

2026: v_round_tax NUMBER;
2027: v_round_base NUMBER;
2028: v_round_func NUMBER;
2029: v_tax_total NUMBER;
2030: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
2031: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
2032: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
2033: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
2034: v_requested_quantity_uom VARCHAR2(3);

Line 2031: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;

2027: v_round_base NUMBER;
2028: v_round_func NUMBER;
2029: v_tax_total NUMBER;
2030: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
2031: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
2032: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
2033: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
2034: v_requested_quantity_uom VARCHAR2(3);
2035: v_conversion_rate NUMBER := 0;

Line 4523: FROM JAI_CMN_INVENTORY_ORGS

4519: AND wnd.delivery_id = wda.delivery_id;
4520:
4521: Cursor c_hr_organizations_cur is
4522: SELECT excise_return_days, sales_return_days
4523: FROM JAI_CMN_INVENTORY_ORGS
4524: WHERE organization_id = pr_new.ship_from_org_id
4525: AND location_id = 0;
4526:
4527: Cursor cur_chk_item_dtls(cp_organization_id IN NUMBER,