APPS.CSP_MINMAX_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 977: FROM mtl_material_transactions_temp mmtt

973:
974: SELECT SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
975: Sign(mmtt.primary_quantity)) * Abs( mmtt.primary_quantity ))
976: INTO l_mmtt_qty1
977: FROM mtl_material_transactions_temp mmtt
978: WHERE mmtt.organization_id = p_org_id
979: AND mmtt.inventory_item_id = p_item_id
980: AND mmtt.posting_flag = 'Y'
981: AND mmtt.subinventory_code IS NOT NULL

Line 994: FROM mtl_material_transactions_temp mmtt

990: print_debug('Total MMTT Trx quantity Source Org : ' || to_char(l_mmtt_qty1), 'get_onhand_qty', 9);
991:
992: SELECT SUM(Abs(mmtt.primary_quantity))
993: INTO l_mmtt_qty2
994: FROM mtl_material_transactions_temp mmtt
995: WHERE decode(mmtt.transaction_action_id,3,
996: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
997: AND mmtt.inventory_item_id = p_item_id
998: AND mmtt.posting_flag = 'Y'

Line 1028: FROM mtl_material_transactions_temp mmtt

1024:
1025: SELECT SUM(Decode(mmtt.transaction_action_id, 1, -1, 2, -1, 28, -1, 3, -1,
1026: Sign(mmtt.primary_quantity)) * Abs( mmtt.primary_quantity ))
1027: INTO l_mmtt_qty1
1028: FROM mtl_material_transactions_temp mmtt
1029: WHERE mmtt.organization_id = p_org_id
1030: AND mmtt.inventory_item_id = p_item_id
1031: AND mmtt.subinventory_code = p_subinv
1032: --AND mmtt.planning_tp_type = 2

Line 1042: FROM mtl_material_transactions_temp mmtt

1038: print_debug('Total MMTT Trx quantity Source Org Sub : ' || to_char(l_mmtt_qty1), 'get_onhand_qty', 9);
1039:
1040: SELECT SUM(Abs(mmtt.primary_quantity))
1041: INTO l_mmtt_qty2
1042: FROM mtl_material_transactions_temp mmtt
1043: WHERE decode(mmtt.transaction_action_id,3,
1044: mmtt.transfer_organization,mmtt.organization_id) = p_org_id
1045: AND mmtt.inventory_item_id = p_item_id
1046: AND mmtt.transfer_subinventory = p_subinv