APPS.CSI_INV_TRXS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 3428: mtl_system_items_b msib,

3424: nvl(msib.eam_item_type,0) eam_item_type, --included for R12,eAM integration
3425: mmt.rcv_transaction_id rcv_transaction_id,
3426: mmt.transfer_transaction_id transfer_transaction_id
3427: FROM
3428: mtl_system_items_b msib,
3429: mtl_serial_numbers msn,
3430: mtl_unit_transactions mut,
3431: mtl_secondary_inventories msi,
3432: hr_all_organization_units haou,

Line 3493: mtl_system_items_b msib,

3489: nvl(msib.eam_item_type,0) eam_item_type, --included for R12,eAM integration
3490: mmt.rcv_transaction_id rcv_transaction_id,
3491: mmt.transfer_transaction_id transfer_transaction_id
3492: FROM
3493: mtl_system_items_b msib,
3494: mtl_serial_numbers msn,
3495: mtl_unit_transactions mut,
3496: mtl_transaction_lot_numbers mtln,
3497: mtl_secondary_inventories msi,

Line 3647: mtl_system_items_b msib,

3643: nvl(msib.eam_item_type,0) eam_item_type, --included for R12,eAM integration
3644: mmt.rcv_transaction_id rcv_transaction_id,
3645: mmt.transfer_transaction_id transfer_transaction_id
3646: FROM
3647: mtl_system_items_b msib,
3648: mtl_serial_numbers msn,
3649: mtl_unit_transactions mut,
3650: mtl_secondary_inventories msi,
3651: hr_all_organization_units haou,

Line 3714: mtl_system_items_b msib,

3710: nvl(msib.eam_item_type,0) eam_item_type, --included for R12,eAM integration
3711: mmt.rcv_transaction_id rcv_transaction_id,
3712: mmt.transfer_transaction_id transfer_transaction_id
3713: FROM
3714: mtl_system_items_b msib,
3715: mtl_serial_numbers msn,
3716: mtl_unit_transactions mut,
3717: mtl_transaction_lot_numbers mtln,
3718: mtl_secondary_inventories msi,

Line 3860: FROM mtl_system_items

3856: l_api_name VARCHAR2(200) := 'CSI_INV_TRXS_PKG.GET_ASSET_CREATION_CODE';
3857: /*Commented for Bug 13988660
3858: CURSOR Asset_CC_Cur (P_Item_Id IN NUMBER) IS
3859: SELECT DISTINCT asset_creation_code
3860: FROM mtl_system_items
3861: WHERE inventory_item_id = p_inventory_item_id
3862: AND organization_id =
3863: (select organization_id
3864: from mtl_system_items

Line 3864: from mtl_system_items

3860: FROM mtl_system_items
3861: WHERE inventory_item_id = p_inventory_item_id
3862: AND organization_id =
3863: (select organization_id
3864: from mtl_system_items
3865: where inventory_item_id=p_inventory_item_id
3866: and rownum=1)
3867: AND enabled_flag = 'Y'
3868: AND nvl (start_date_active, l_sysdate) <= l_sysdate

Line 3874: FROM mtl_system_items

3870: */
3871: --Added for Bug 13988660
3872: CURSOR Asset_CC_Cur (P_Item_Id IN NUMBER, P_Org_Id IN NUMBER) IS
3873: SELECT asset_creation_code
3874: FROM mtl_system_items
3875: WHERE inventory_item_id = p_inventory_item_id
3876: AND organization_id = p_organization_id
3877: AND enabled_flag = 'Y'
3878: AND nvl (start_date_active, l_sysdate) <= l_sysdate

Line 3909: FROM mtl_system_items

3905: l_err_text VARCHAR2(2000);
3906: l_api_name VARCHAR2(200) := 'CSI_INV_TRXS_PKG.CHECK_ITEM_TRACKABLE';
3907: CURSOR NL_TRACK_CUR(P_Item_Id IN NUMBER) IS
3908: SELECT DISTINCT 'Y'
3909: FROM mtl_system_items
3910: WHERE inventory_item_id = p_item_id
3911: AND organization_id =
3912: (select organization_id
3913: from mtl_system_items

Line 3913: from mtl_system_items

3909: FROM mtl_system_items
3910: WHERE inventory_item_id = p_item_id
3911: AND organization_id =
3912: (select organization_id
3913: from mtl_system_items
3914: where inventory_item_id=P_inventory_item_id
3915: and rownum =1)
3916: AND enabled_flag = 'Y'
3917: AND nvl (start_date_active, l_sysdate) <= l_sysdate