DBA Data[Home] [Help]

APPS.JAI_INV_MMT_TRIGGER_PKG dependencies on JAI_INV_SUBINV_DTLS

Line 106: FROM JAI_INV_SUBINV_DTLS

102:
103: CURSOR loc_id_cur (p_subinv_code IN VARCHAR2, p_organization_id IN NUMBER)
104: IS
105: SELECT location_id
106: FROM JAI_INV_SUBINV_DTLS
107: WHERE sub_inventory_name = p_subinv_code
108: AND organization_id = p_organization_id;
109:
110: CURSOR item_class_cur (p_inv_item_id IN NUMBER, p_organization_id IN NUMBER)

Line 208: FROM JAI_INV_SUBINV_DTLS

204:
205: /*
206: CURSOR c_subinv_flags(p_subinv_code IN Varchar2, p_organization_id IN NUMBER) IS
207: SELECT bonded
208: FROM JAI_INV_SUBINV_DTLS
209: WHERE sub_inventory_name = p_subinv_code AND
210: organization_id = p_organization_id;
211: */
212: --added on 04/99/99

Line 219: FROM JAI_INV_SUBINV_DTLS

215: p_organization_id IN NUMBER
216: )
217: IS
218: SELECT bonded, trading
219: FROM JAI_INV_SUBINV_DTLS
220: WHERE sub_inventory_name = p_subinv_code
221: AND organization_id = p_organization_id;
222:
223: CURSOR fetch_type_name(v_transaction_type_id IN NUMBER)