DBA Data[Home] [Help]

APPS.INV_MGD_POSITIONS_PROC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 464: FROM mtl_material_transactions

460: SELECT
461: NVL(SUM(primary_quantity), 0)
462: INTO
463: l_rollback_qty
464: FROM mtl_material_transactions
465: WHERE organization_id = p_organization_id
466: AND inventory_item_id = p_item_id
467: AND transaction_date >= p_date
468: AND transaction_action_id NOT IN (24,30,50,51,52); /* Bug #3194333 (Container Pack (50),Unpack(51) and Split(52) txns to be excluded) */

Line 529: FROM mtl_material_transactions

525: SELECT
526: NVL(SUM(primary_quantity), 0)
527: INTO
528: l_org_received_qty
529: FROM mtl_material_transactions
530: WHERE organization_id = p_item_rec.organization_id
531: AND inventory_item_id = p_item_rec.item_id
532: AND transaction_date >= p_bucket_rec.start_date
533: AND transaction_date < p_bucket_rec.end_date

Line 542: FROM mtl_material_transactions

538: SELECT
539: NVL(SUM(-primary_quantity), 0)
540: INTO
541: l_org_issued_qty
542: FROM mtl_material_transactions
543: WHERE organization_id = p_item_rec.organization_id
544: AND inventory_item_id = p_item_rec.item_id
545: AND transaction_date >= p_bucket_rec.start_date
546: AND transaction_date < p_bucket_rec.end_date