DBA Data[Home] [Help]

APPS.FLM_KANBAN_TRANSFER dependencies on MTL_ONHAND_QUANTITIES

Line 1106: FROM mtl_onhand_quantities moq,

1102: -- *****************************************************
1103: CURSOR c_qty_on_hand(p_kanban_card_id IN NUMBER)
1104: IS
1105: SELECT SUM(moq.transaction_quantity) transaction_quantity
1106: FROM mtl_onhand_quantities moq,
1107: mtl_kanban_cards mkc
1108: WHERE mkc.inventory_item_id = moq.inventory_item_id
1109: AND mkc.SOURCE_organization_id = moq.organization_id
1110: AND mkc.source_subinventory = moq.subinventory_code