DBA Data[Home] [Help]

APPS.CSI_INV_TRXS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 3022: mtl_system_items_b msib,

3018: nvl(msib.eam_item_type,0) eam_item_type, --included for R12,eAM integration
3019: mmt.rcv_transaction_id rcv_transaction_id,
3020: mmt.transfer_transaction_id transfer_transaction_id
3021: FROM
3022: mtl_system_items_b msib,
3023: mtl_serial_numbers msn,
3024: mtl_unit_transactions mut,
3025: mtl_secondary_inventories msi,
3026: hr_all_organization_units haou,

Line 3087: mtl_system_items_b msib,

3083: nvl(msib.eam_item_type,0) eam_item_type, --included for R12,eAM integration
3084: mmt.rcv_transaction_id rcv_transaction_id,
3085: mmt.transfer_transaction_id transfer_transaction_id
3086: FROM
3087: mtl_system_items_b msib,
3088: mtl_serial_numbers msn,
3089: mtl_unit_transactions mut,
3090: mtl_transaction_lot_numbers mtln,
3091: mtl_secondary_inventories msi,

Line 3229: FROM mtl_system_items

3225: l_err_text VARCHAR2(2000);
3226: l_api_name VARCHAR2(200) := 'CSI_INV_TRXS_PKG.GET_ASSET_CREATION_CODE';
3227: CURSOR Asset_CC_Cur (P_Item_Id IN NUMBER) IS
3228: SELECT DISTINCT asset_creation_code
3229: FROM mtl_system_items
3230: WHERE inventory_item_id = p_inventory_item_id
3231: AND organization_id =
3232: (select organization_id
3233: from mtl_system_items

Line 3233: from mtl_system_items

3229: FROM mtl_system_items
3230: WHERE inventory_item_id = p_inventory_item_id
3231: AND organization_id =
3232: (select organization_id
3233: from mtl_system_items
3234: where inventory_item_id=p_inventory_item_id
3235: and rownum=1)
3236: AND enabled_flag = 'Y'
3237: AND nvl (start_date_active, l_sysdate) <= l_sysdate

Line 3267: FROM mtl_system_items

3263: l_err_text VARCHAR2(2000);
3264: l_api_name VARCHAR2(200) := 'CSI_INV_TRXS_PKG.CHECK_ITEM_TRACKABLE';
3265: CURSOR NL_TRACK_CUR(P_Item_Id IN NUMBER) IS
3266: SELECT DISTINCT 'Y'
3267: FROM mtl_system_items
3268: WHERE inventory_item_id = p_item_id
3269: AND organization_id =
3270: (select organization_id
3271: from mtl_system_items

Line 3271: from mtl_system_items

3267: FROM mtl_system_items
3268: WHERE inventory_item_id = p_item_id
3269: AND organization_id =
3270: (select organization_id
3271: from mtl_system_items
3272: where inventory_item_id=P_inventory_item_id
3273: and rownum =1)
3274: AND enabled_flag = 'Y'
3275: AND nvl (start_date_active, l_sysdate) <= l_sysdate