APPS.JAI_MTL_TRXS_PKG dependencies on JAI_INV_SUBINV_DTLS

Line 466: JAI_INV_SUBINV_DTLS subinv,

462: trx.created_by,
463: trx.last_update_date,
464: trx.last_update_login
465: FROM jai_mtl_trxs trx,
466: JAI_INV_SUBINV_DTLS subinv,
467: JAI_INV_ITM_SETUPS itm
468: WHERE subinv.organization_id = trx.to_organization
469: AND itm.organization_id = trx.to_organization
470: AND itm.inventory_item_id = trx.inventory_item_id

Line 1571: FROM JAI_INV_SUBINV_DTLS

1567:
1568: CURSOR c_get_location(p_organization_id IN NUMBER , p_subinventory IN VARCHAR2)
1569: IS
1570: SELECT location_id
1571: FROM JAI_INV_SUBINV_DTLS
1572: WHERE organization_id = p_organization_id
1573: AND sub_inventory_name = p_subinventory;
1574:
1575: CURSOR c_get_ja_accts(p_organization_id NUMBER , p_location_id number) IS

Line 1623: FROM JAI_INV_SUBINV_DTLS

1619:
1620: CURSOR c_get_bonded(p_organization_id IN NUMBER , p_subinventory IN VARCHAR2)/*6487803*/
1621: IS
1622: SELECT bonded
1623: FROM JAI_INV_SUBINV_DTLS
1624: WHERE organization_id = p_organization_id
1625: AND sub_inventory_name = p_subinventory;
1626:
1627: lv_bonded JAI_INV_SUBINV_DTLS.bonded%TYPE; /*6487803*/

Line 1627: lv_bonded JAI_INV_SUBINV_DTLS.bonded%TYPE; /*6487803*/

1623: FROM JAI_INV_SUBINV_DTLS
1624: WHERE organization_id = p_organization_id
1625: AND sub_inventory_name = p_subinventory;
1626:
1627: lv_bonded JAI_INV_SUBINV_DTLS.bonded%TYPE; /*6487803*/
1628:
1629:
1630:
1631: BEGIN

Line 2890: FROM jai_inv_subinv_dtls

2886: CURSOR cur_get_bonded(cp_organization_id NUMBER,
2887: cp_sub_inventory VARCHAR2)
2888: IS
2889: SELECT bonded
2890: FROM jai_inv_subinv_dtls
2891: WHERE organization_id = cp_organization_id
2892: AND sub_inventory_name = cp_sub_inventory;
2893:
2894: ln_cost_amount NUMBER;

Line 2895: lv_bonded jai_inv_subinv_dtls.bonded%TYPE;

2891: WHERE organization_id = cp_organization_id
2892: AND sub_inventory_name = cp_sub_inventory;
2893:
2894: ln_cost_amount NUMBER;
2895: lv_bonded jai_inv_subinv_dtls.bonded%TYPE;
2896: ln_ppv_acct_id NUMBER;/*6487489*/
2897:
2898:
2899: /*rchandan for bug#6487489..end*/

Line 5414: FROM JAI_INV_SUBINV_DTLS

5410: v_location_id NUMBER;
5411:
5412: CURSOR Location_Cursor IS
5413: SELECT Location_id
5414: FROM JAI_INV_SUBINV_DTLS
5415: WHERE Sub_Inventory_Name = p_subinventory_code
5416: AND organization_id = p_organization_id; */
5417: /*End Commenting by mmurtuza for removing GST Changes*/
5418: