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 1109: JAI_CMN_INVENTORY_ORGS

1105: vat_return_days ,
1106: nvl(manufacturing,'N') manufacturing,
1107: nvl(trading,'N') trading
1108: FROM
1109: JAI_CMN_INVENTORY_ORGS
1110: WHERE
1111: organization_id = pr_new.ship_from_org_id
1112: AND location_id = 0 ;
1113:

Line 1156: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;

1152: lv_check_vat_type_exists VARCHAR2(1);
1153: v_date_ordered DATE;
1154: v_date_confirmed DATE;
1155: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1156: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1157: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1158: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1159: v_excise_flag VARCHAR2(1);
1160: v_sales_flag VARCHAR2(1);

Line 1157: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;

1153: v_date_ordered DATE;
1154: v_date_confirmed DATE;
1155: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1156: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1157: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1158: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1159: v_excise_flag VARCHAR2(1);
1160: v_sales_flag VARCHAR2(1);
1161: v_vat_flag VARCHAR2(1);

Line 1158: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;

1154: v_date_confirmed DATE;
1155: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
1156: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
1157: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
1158: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE;
1159: v_excise_flag VARCHAR2(1);
1160: v_sales_flag VARCHAR2(1);
1161: v_vat_flag VARCHAR2(1);
1162: v_round_tax NUMBER;

Line 1166: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;

1162: v_round_tax NUMBER;
1163: v_round_base NUMBER;
1164: v_round_func NUMBER;
1165: v_tax_total NUMBER;
1166: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
1167: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
1168: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
1169: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
1170: v_requested_quantity_uom VARCHAR2(3);

Line 1167: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;

1163: v_round_base NUMBER;
1164: v_round_func NUMBER;
1165: v_tax_total NUMBER;
1166: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type;
1167: v_trading JAI_CMN_INVENTORY_ORGS.trading%type;
1168: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
1169: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
1170: v_requested_quantity_uom VARCHAR2(3);
1171: v_conversion_rate NUMBER := 0;

Line 3532: JAI_CMN_INVENTORY_ORGS

3528: SELECT
3529: excise_return_days,
3530: sales_return_days
3531: FROM
3532: JAI_CMN_INVENTORY_ORGS
3533: WHERE
3534: organization_id = pr_new.ship_from_org_id
3535: AND location_id = 0;
3536: