Bro, mau tau itu buat bikin report apa ya ...., tadi g tanya sama orang apps di
tempat g katanya nilainya itu dari receiving.
denny <[EMAIL PROTECTED]> wrote: Dear rekan-rekan
@ Indo-Oracle,
dikantor saya, menggunakan Oracle Apps v.11i, pada responsibility Inventory,
ada menu Onhand Availability-Onhand Quantity.
jika sudah masuk menu tersebut, bila telah dipilih item yang ingin dilihat,
maka akan muncul menu layar Material Workbench, dan ada tombol Availability.
jika diklik tombol Availability, maka muncul tampilan availability.
yang jadi pertanyaan saya, data pada kolom Available to Reserve didapat dari
table mana ya?
saya sudah cek query dari form inventory tersebut dan hanya didapatkan data
onhand saja yaitu (19500).
perintah query dari form tsb adalah :
SELECT ORGANIZATION_ID, ORGANIZATION_CODE,SUBINVENTORY_CODE,
LOCATOR_ID,LOCATOR,PROJECT_ID,TASK_ID,INVENTORY_ITEM_ID,ITEM_DESCRIPTION,ITEM,UOM,REVISION,ON_HAND,UNPACKED,PACKED,COST_GROUP_ID,LPN_ID,LPN,LOT_NUMBER,SERIAL_NUMBER,UNIT_NUMBER,PLANNING_ORGANIZATION_ID,PLANNING_TP_TYPE,OWNING_ORGANIZATION_ID,OWNING_TP_TYPE,SUBINVENTORY_STATUS_ID,LPN_CONTEXT,ITEM_LOT_CONTROL,ITEM_SERIAL_CONTROL
FROM MTL_ONHAND_DUMMY_V WHERE 1=0
UNION ALL SELECT organization_id, organization_code, subinventory_code,
locator_id, locator, project_id, task_id, inventory_item_id, item_description,
item, uom, revision, sum(on_hand) on_hand, sum(unpacked) unpacked, sum(packed)
packed, cost_group_id, to_number(null) lpn_id, to_char(null) lpn, lot_number,
to_char(null) serial_number, to_char(null) unit_number,
planning_organization_id,planning_tp_type,
owning_organization_id,owning_tp_type, to_number(null) status_id,
to_number(null) lpn_context ,item_lot_control, item_serial_control FROM
MTL_ONHAND_TOTAL_MWB_V WHERE 1=1 AND containerized_flag is null AND
inventory_item_id = '541' AND locator_id = '1' AND subinventory_code = 'Pharma'
AND organization_id = '105' GROUP BY organization_id , organization_code ,
subinventory_code , locator_id, locator, project_id, task_id ,
inventory_item_id, item_description, item, uom , revision , cost_group_id ,
lot_number ,planning_organization_id,planning_tp_type
,owning_organization_id,owning_tp_type ,item_lot_control,item_serial_control
HAVING 1=1
UNION ALL SELECT organization_id, organization_code, subinventory_code,
locator_id, locator, project_id, task_id, inventory_item_id,item_description,
item, uom, revision, on_hand, unpacked, packed, cost_group_id, lpn_id, lpn,
lot_number, serial_number, unit_number,planning_organization_id,
planning_tp_type,owning_organization_id,owning_tp_type,
subinventory_status_id,lpn_context,item_lot_control,item_serial_control FROM
mtl_onhand_dummy_v WHERE 1=0 order by ITEM, ORGANIZATION_ID,
SUBINVENTORY_CODE, LOCATOR.
mohon bantuannya, karena saya sudah mencari disemua table dischema INV, tapi
tidak menemukan dari mana asalah angka 15675 tsb.
terima kasih.
regards,
denny l
[Non-text portions of this message have been removed]
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
[Non-text portions of this message have been removed]
