APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on JAI_INV_SUBINV_DTLS

Line 39: v_bonded JAI_INV_SUBINV_DTLS.bonded%TYPE;

35: v_source_header_type_id NUMBER ;
36: v_shipped_quantity NUMBER ;
37: v_matched_qty NUMBER ;
38: v_trading_flag VARCHAR2(1) ;
39: v_bonded JAI_INV_SUBINV_DTLS.bonded%TYPE;
40: v_trad_register_code VARCHAR2(30) ;
41: v_item_trading_flag VARCHAR2(1) ;
42: v_location_id NUMBER ;
43: v_exe_flag VARCHAR2(150) ;

Line 56: JAI_INV_SUBINV_DTLS

52: NVL(Location_id,0),
53: trading,
54: NVL(bonded,'N') bonded
55: FROM
56: JAI_INV_SUBINV_DTLS
57: WHERE
58: Sub_Inventory_Name = v_subinventory AND
59: organization_id = v_organization_id ;
60:

Line 617: FROM JAI_INV_SUBINV_DTLS

613:
614: CURSOR Location_Cursor IS
615: SELECT NVL(Location_id,0),
616: trading
617: FROM JAI_INV_SUBINV_DTLS
618: WHERE Sub_Inventory_Name = v_subinventory
619: AND organization_id = v_organization_id;
620:
621: CURSOR get_ship_to_org_id_cur( p_line_id NUMBER) IS

Line 716: FROM JAI_INV_SUBINV_DTLS A

712: inventory_item_id = p_item_id;
713:
714: CURSOR bonded_cur(p_organization_id NUMBER, p_subinventory VARCHAR2) IS
715: SELECT NVL(A.bonded,'Y') bonded
716: FROM JAI_INV_SUBINV_DTLS A
717: WHERE A.sub_inventory_name = p_subinventory
718: AND A.organization_id = p_organization_id;
719:
720: CURSOR fin_year_cur(p_organization_id IN NUMBER) IS

Line 2834: FROM JAI_INV_SUBINV_DTLS

2830:
2831: CURSOR Location_Cursor IS
2832: SELECT NVL(Location_id,0),
2833: trading
2834: FROM JAI_INV_SUBINV_DTLS
2835: WHERE Sub_Inventory_Name = v_subinventory
2836: AND organization_id = v_organization_id;
2837:
2838: CURSOR item_trading_cur IS

Line 3199: FROM JAI_INV_SUBINV_DTLS

3195: AND jrttv.regime_code = jai_constants.tcs_regime;
3196:
3197: CURSOR c_location_id IS
3198: SELECT NVL(Location_id,0)
3199: FROM JAI_INV_SUBINV_DTLS
3200: WHERE Sub_Inventory_Name = v_subinventory
3201: AND organization_id = v_organization_id;
3202:
3203: BEGIN

Line 3833: FROM JAI_INV_SUBINV_DTLS

3829: where delivery_id = p_delivery_id;
3830:
3831: CURSOR c_get_loc_id (cp_subinventory wsh_delivery_details.SUBINVENTORY%TYPE, cp_organization_id wsh_delivery_details.ORGANIZATION_ID%TYPE)IS
3832: SELECT Location_id
3833: FROM JAI_INV_SUBINV_DTLS
3834: WHERE Sub_Inventory_Name = cp_subinventory
3835: AND organization_id = cp_organization_id;
3836:
3837: CURSOR c_reg_num(cp_regime_id number,cp_organization_id wsh_delivery_details.ORGANIZATION_ID%TYPE , cp_location_id wsh_delivery_details.ship_to_location_id%TYPE ) IS