DBA Data[Home] [Help]

APPS.JAI_OM_RMA_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;

46: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;
47: v_tax_category_id JAI_OM_WSH_LINES_ALL.tax_category_id % TYPE;
48: v_tax_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;
49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
51: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
52: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE; -- added, Harshita for bug#4245062
53: v_excise_flag VARCHAR2(1);
54: v_sales_flag VARCHAR2(1);

Line 51: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;

47: v_tax_category_id JAI_OM_WSH_LINES_ALL.tax_category_id % TYPE;
48: v_tax_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;
49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
51: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
52: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE; -- added, Harshita for bug#4245062
53: v_excise_flag VARCHAR2(1);
54: v_sales_flag VARCHAR2(1);
55: v_vat_flag VARCHAR2(1); -- added, Harshita for bug#4245062

Line 52: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE; -- added, Harshita for bug#4245062

48: v_tax_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;
49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
51: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
52: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE; -- added, Harshita for bug#4245062
53: v_excise_flag VARCHAR2(1);
54: v_sales_flag VARCHAR2(1);
55: v_vat_flag VARCHAR2(1); -- added, Harshita for bug#4245062
56: v_vat_attribute VARCHAR2(1); -- added, Harshita for bug#4245062

Line 73: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type; --Added by Nagaraj.s for Bug3113027

69: v_rate_per_unit JAI_OM_OE_RMA_LINES.rate_per_unit % TYPE;
70: v_excise_total NUMBER;
71: v_rate_total NUMBER;
72: v_qty_total NUMBER;
73: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type; --Added by Nagaraj.s for Bug3113027
74: v_trading JAI_CMN_INVENTORY_ORGS.trading%type; --Added by Nagaraj.s for Bug3113027
75: v_service_type_code JAI_OM_OE_SO_LINES.service_type_code%type; /* added by ssawant for bug 5879769 */
76:
77: -- added by Allen Yang for bug 9666476 28-apr-2010, begin

Line 74: v_trading JAI_CMN_INVENTORY_ORGS.trading%type; --Added by Nagaraj.s for Bug3113027

70: v_excise_total NUMBER;
71: v_rate_total NUMBER;
72: v_qty_total NUMBER;
73: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type; --Added by Nagaraj.s for Bug3113027
74: v_trading JAI_CMN_INVENTORY_ORGS.trading%type; --Added by Nagaraj.s for Bug3113027
75: v_service_type_code JAI_OM_OE_SO_LINES.service_type_code%type; /* added by ssawant for bug 5879769 */
76:
77: -- added by Allen Yang for bug 9666476 28-apr-2010, begin
78: lv_shippable_flag VARCHAR2(1);

Line 158: FROM JAI_CMN_INVENTORY_ORGS

154: wnd.delivery_id = wda.delivery_id;
155:
156: Cursor c_hr_organizations_cur( v_organization_id number ) is
157: SELECT vat_return_days
158: FROM JAI_CMN_INVENTORY_ORGS
159: WHERE organization_id = v_organization_id
160: AND location_id = 0;
161:
162: v_ordered_date date ;

Line 452: FROM JAI_CMN_INVENTORY_ORGS

448: ELSIF NVL(lv_shippable_flag, 'Y') = 'N'
449: THEN
450: -- added by Allen Yang for bug 9691880 10-May-2010, begin
451: FOR hr_rec IN (SELECT vat_return_days
452: FROM JAI_CMN_INVENTORY_ORGS
453: WHERE organization_id = p_warehouse_id
454: AND location_id = 0)
455: LOOP
456: v_vat_return_days := hr_rec.vat_return_days ;

Line 728: FROM JAI_CMN_INVENTORY_ORGS

724: sales_return_days,
725: vat_return_days , -- added, Harshita for bug#4245062
726: nvl(manufacturing,'N') manufacturing, --Added Manufacturing and Trading by Nagaraj.s for bug3113027
727: nvl(trading,'N') trading
728: FROM JAI_CMN_INVENTORY_ORGS
729: WHERE organization_id = p_warehouse_id
730: AND location_id = 0)
731: LOOP
732: v_excise_return_days := hr_rec.excise_return_days;