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_OE_OLA_TRIGGER_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 1290: JAI_CMN_INVENTORY_ORGS

1286: vat_return_days ,
1287: nvl(manufacturing,'N') manufacturing,
1288: nvl(trading,'N') trading
1289: FROM
1290: JAI_CMN_INVENTORY_ORGS
1291: WHERE
1292: organization_id = pr_new.ship_from_org_id
1293: AND location_id = 0 ;
1294:

Line 1352: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;

1348: lv_check_vat_type_exists VARCHAR2(1);
1349: v_date_ordered DATE;
1350: v_date_confirmed DATE;
1351: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1352: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1353: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1354: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1355: v_excise_flag VARCHAR2(1);
1356: v_sales_flag VARCHAR2(1);

Line 1353: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;

1349: v_date_ordered DATE;
1350: v_date_confirmed DATE;
1351: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1352: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1353: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1354: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1355: v_excise_flag VARCHAR2(1);
1356: v_sales_flag VARCHAR2(1);
1357: v_vat_flag VARCHAR2(1);

Line 1354: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;

1350: v_date_confirmed DATE;
1351: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1352: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1353: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1354: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1355: v_excise_flag VARCHAR2(1);
1356: v_sales_flag VARCHAR2(1);
1357: v_vat_flag VARCHAR2(1);
1358: v_round_tax NUMBER;

Line 1362: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;

1358: v_round_tax NUMBER;
1359: v_round_base NUMBER;
1360: v_round_func NUMBER;
1361: v_tax_total NUMBER;
1362: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
1363: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
1364: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
1365: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
1366: v_requested_quantity_uom VARCHAR2(3);

Line 1363: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;

1359: v_round_base NUMBER;
1360: v_round_func NUMBER;
1361: v_tax_total NUMBER;
1362: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
1363: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
1364: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
1365: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
1366: v_requested_quantity_uom VARCHAR2(3);
1367: v_conversion_rate NUMBER := 0;

Line 2207: JAI_CMN_INVENTORY_ORGS

2203: vat_return_days ,
2204: nvl(manufacturing,'N') manufacturing,
2205: nvl(trading,'N') trading
2206: FROM
2207: JAI_CMN_INVENTORY_ORGS
2208: WHERE
2209: organization_id = pr_new.ship_from_org_id
2210: AND location_id = 0 ;
2211:

Line 2262: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;

2258: lv_check_vat_type_exists VARCHAR2(1);
2259: v_date_ordered DATE;
2260: v_date_confirmed DATE;
2261: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
2262: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
2263: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
2264: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
2265: v_excise_flag VARCHAR2(1);
2266: v_sales_flag VARCHAR2(1);

Line 2263: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;

2259: v_date_ordered DATE;
2260: v_date_confirmed DATE;
2261: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
2262: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
2263: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
2264: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
2265: v_excise_flag VARCHAR2(1);
2266: v_sales_flag VARCHAR2(1);
2267: v_vat_flag VARCHAR2(1);

Line 2264: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;

2260: v_date_confirmed DATE;
2261: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
2262: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
2263: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
2264: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
2265: v_excise_flag VARCHAR2(1);
2266: v_sales_flag VARCHAR2(1);
2267: v_vat_flag VARCHAR2(1);
2268: v_round_tax NUMBER;

Line 2272: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;

2268: v_round_tax NUMBER;
2269: v_round_base NUMBER;
2270: v_round_func NUMBER;
2271: v_tax_total NUMBER;
2272: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
2273: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
2274: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
2275: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
2276: v_requested_quantity_uom VARCHAR2(3);

Line 2273: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;

2269: v_round_base NUMBER;
2270: v_round_func NUMBER;
2271: v_tax_total NUMBER;
2272: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
2273: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
2274: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
2275: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
2276: v_requested_quantity_uom VARCHAR2(3);
2277: v_conversion_rate NUMBER := 0;

Line 5638: JAI_CMN_INVENTORY_ORGS

5634: SELECT
5635: excise_return_days,
5636: sales_return_days
5637: FROM
5638: JAI_CMN_INVENTORY_ORGS
5639: WHERE
5640: organization_id = pr_new.ship_from_org_id
5641: AND location_id = 0;
5642: